Re: calculate size of a data type used in a create table stmt

On 15 Sep, 06:55, fresher <prashanth3..._at_gmail.com> wrote:
> Hi,
>
> I would like to know if there is any way to find out the length  of
> datatype mentioned in a create table stmt.
> For example:
>   create table employee(empno number(3),empname varchar(10));
>
> in the above DDL i have mentioned the size of my number datatype as 3.
> is there a way to retrieve that info.?
> apart from desc<table_name>???????
>
> Thanks in advance

Oracle version?

Anyway, check out the DBA_TAB_COLS view.

HTH -g Received on Mon Sep 15 2008 - 08:21:42 CDT