Re: calculate size of a data type used in a create table stmt
Date: Mon, 15 Sep 2008 06:21:42 -0700 (PDT)
On 15 Sep, 06:55, fresher <prashanth3..._at_gmail.com> wrote:
> 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
Anyway, check out the DBA_TAB_COLS view.
HTH -g Received on Mon Sep 15 2008 - 08:21:42 CDT