RE: about CTAS and column definition

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_at_cetelem.fr] 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 Received on Wed Apr 27 2005 - 11:31:29 CDT