about CTAS and column definition

From: NGUYEN Philippe (Cetelem) <philippe.nguyen_at_cetelem.fr>
Date: Wed, 27 Apr 2005 17:09:15 +0200
Message-ID: <ABDF0B66BB2D194FBA86112DA70C5FC1515EFB@ngmail3.ctlmcofnt.ms.fr.cnet.intra>

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