Re: Finding data type for a column

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 CEST