RE: about CTAS and column definition

From: "Mercadante, Thomas F (LABOR)" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
To: "'philippe.nguyen@xxxxxxxxxx'" <philippe.nguyen@xxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 27 Apr 2005 11:26:55 -0400

Philippe,

You can do it this way:

create table B as select sum(ctas.numcli) as numcli from A where rownum < 1;
alter table b modify(numcli number(3));
insert into b as select sum(ctas.numcli) from a;


Tom

-----Original Message-----
From: NGUYEN Philippe (Cetelem) [mailto:philippe.nguyen@xxxxxxxxxx] 
Sent: Wednesday, April 27, 2005 11:09 AM
To: oracle-l
Subject: 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
--
http://www.freelists.org/webpage/oracle-l

RE: about CTAS and column definition

Other related posts: