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

From: fresher <>
Date: Sun, 14 Sep 2008 22:55:12 -0700 (PDT)
Message-ID: <>


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

Original text of this message