Re: calculate size of a data type used in a create table stmt
From: Palooka <nobody_at_nowhere.com>
Date: Mon, 15 Sep 2008 22:35:48 +0100
Message-ID: <SyAzk.31365$t_1.9355@newsfe30.ams2>
>> 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
OP owns the table. COLS will suffice.
Date: Mon, 15 Sep 2008 22:35:48 +0100
Message-ID: <SyAzk.31365$t_1.9355@newsfe30.ams2>
gazzag wrote:
> 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. >
OP owns the table. COLS will suffice.
Palooka Received on Mon Sep 15 2008 - 16:35:48 CDT