Re: Finding data type for a column
From: Michael Abbey <msabbey_at_magi.com>
Date: 1996/10/24
Message-ID: <326FB80E.1BD1_at_magi.com>#1/1
Date: 1996/10/24
Message-ID: <326FB80E.1BD1_at_magi.com>#1/1
Bob Woodward wrote:
>
> Jedi 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.
> >
select date_type from cols,all_tables
where table_name = 'STUDENTS'
and column_name = 'ADDRESS' and owner
and cols.table_name = all_tables.table_name
and all_tables.owner = 'QQ';
In this SQL statement "QQ" is the owner of the STUDENTS table.
Michael
################################################################### # Michael Abbey Ottawa ON Canada 613 780 2364 # # Co-author of: Tuning Oracle Oracle: A Beginner's Guide # Oracle Data Warehousing ###################################################################Received on Thu Oct 24 1996 - 00:00:00 CEST