Re: Finding data type for a column

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1996/10/24
Message-ID: <54ot6i$959@shadow.CSUFresno.EDU>#1/1

Please use the new newsgroup comp.databases.oracle.misc

Try:

Select data_type from user_tab_columns where table_name='STUDENTS'
and column_name='ADDRESS';

Regards,
Steve Cosner

In article <Pine.SUN.3.95.961023163410.22727A-100000_at_krips.eecom.gatech.edu>, Jedi <jedi_at_krips.eecom.gatech.edu> wrote:
>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.
Received on Thu Oct 24 1996 - 00:00:00 CDT