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

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 Received on Mon Sep 15 2008 - 00:55:12 CDT