Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> about CTAS and column definition
Hi list,
just a little problem :
SQL> desc A
Name Type Nullable Default Comments
------ --------- -------- ------- --------
NUMCLI NUMBER(3) Y
SQL> create table B as select sum(ctas.numcli) as numcli from A;
Table created
SQL> desc ctas3
Name Type Nullable Default Comments
------ ------ -------- ------- --------
NUMCLI NUMBER Y
In table B, how can I make column numcli have number(3) type not just number
column definition using "Create Table As Select" method ? Is it possible ?
TIA
Philippe
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 27 2005 - 11:12:46 CDT