Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> about CTAS and column definition

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US