About SQL field Type

Hi Friends
I have question.
I connected oracle and MS access tables(via Delphi7).
I wanna get type of field in indicated table. For example if it is
integer or boolean e.t.c

Please tell me the SQL function or whatever that retrievs type of field.
Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Ulan yrysbaev (ulasir@.yahoo.com) writes:
> Hi Friends
> I have question.
> I connected oracle and MS access tables(via Delphi7).
> I wanna get type of field in indicated table. For example if it is
> integer or boolean e.t.c
> Please tell me the SQL function or whatever that retrievs type of field.

Since you use different platforms, you should be using the
INFORMATION_SCHEMA views, which are part of the ANSI standard. But
I have no idea whether any of Access and Oracle supports them.

You are probably better off asking in comp.databases.ms-access and
comp.databases.oracle.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

About data mining trainings for SQL Server 2005

Hi, all here,

I really wanna know when will some data mining trainings (trainings for delivering business intelligence solutions with data mining functionality in SQL Server 2005) for SQL Server 2005 be available then?

Thanks a lot for any information.

The eLearning and certification folks at Microsoft are working on advanced certifications and associated training material for BI Developers that will likely be available later this year. See this page for more information: http://www.microsoft.com/learning/mcp/mcitp/bid/default.mspx (Course 2796 will include data mining).|||

Solid Quality Learning also offers a SQL Server Data Mining course. If you're interested, I gave a 2 day course in Copenhagen last year and the slides are in the whitepapers section at sqlserverdatamining.com (free login required)

http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/Links_LinkRedirector.aspx?id=3584

The slides are a bit sparse (I think I wrote most of them on the plane), but have a pretty broad coverage of the technical side of the platform.

|||Hi, Raman,thanks a lot. And would those courses available in the UK at the time you mentioned above? Thanks a lot.|||Hi, Jamie, thanks a lot.