Re: Using DESCRIBE to find datatype

From: <poohland_at_hotmail.com>
Date: Thu, 16 Jul 1998 23:48:08 GMT
Message-ID: <6om3fo$4bo$1@nnrp1.dejanews.com>

Use

Select data_type, data_length from dba_tab_columns where table_name='XXX';

Winnie Liu

In article <6oimq2$1v1$1_at_nnrp1.dejanews.com>, 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 16 1998 - 18:48:08 CDT