Re: Finding data type for a column

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
###################################################################