about CTAS and column definition
- From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Apr 2005 17:09:15 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
