Re: Using DESCRIBE to find datatype

Dratz_at_my-dejanews.com wrote:
>
> I am trying to build a complex function and one of the things I need is the
> column datatype of an existing column. I know I can find out from using
> DESCRIBE, but is there another generic table or view where I can find this?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Yeah, if I understand your question correctly, you can use an SQL statement to retrieve that information, such as:

select column_name, data_type from dba_tab_columns where table_name='TABLENAME';

That would get you the same thing as a describe, almost... Received on Wed Jul 15 1998 - 12:05:58 CDT