Re: Using DESCRIBE to find datatype

From: Chris Hamilton <toneczar_at_erols.com>
Date: Wed, 15 Jul 1998 18:21:51 GMT
Message-ID: <6ois3s$llt$1@goo.nwd.usace.army.mil>

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?

user_tab_colums
all_tab_columns
dba_tab_columns

Look at the data_type column.

Chris

---

Chris Hamilton, DBA
US Army Corps of Engineers
christopher.h.hamilton_at_usace.army.mil
http://www.serve.com/cowpb/chamilton.html Received on Wed Jul 15 1998 - 13:21:51 CDT