calculate size of a data type used in a create table stmt
Date: Sun, 14 Sep 2008 22:55:12 -0700 (PDT)
I would like to know if there is any way to find out the length of
datatype mentioned in a create table stmt.
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 Received on Mon Sep 15 2008 - 00:55:12 CDT