Re: Finding data type for a column

From: Michel Lalonde <michel.lalonde_at_sit.ulaval.ca>
Date: 1996/10/24
Message-ID: <michel.lalonde.89.0009A34E@sit.ulaval.ca>#1/1

In article <Pine.SUN.3.95.961023163410.22727A-100000_at_krips.eecom.gatech.edu> Jedi <jedi_at_krips.eecom.gatech.edu> writes:
>From: Jedi <jedi_at_krips.eecom.gatech.edu>
>Subject: Finding data type for a column
>Date: Wed, 23 Oct 1996 16:38:20 -0400

>Hi,
> I am trying to find out the data type of an column from within my
>applicaton.
>What is the ODBC or SQL statment to do that? For example, I have a table
>called
>Students and I want to know what data type the column name Address
>belongs to.

>Thanks in advance for any suggestions or comments

>Dennis

Look at the ALL_TAB_COLUMNS or USER_TAB_COLUMNS data dictionary views for the definition of all the table columns.

Michel Lalonde. Received on Thu Oct 24 1996 - 00:00:00 CDT