RE: about CTAS and column definition
- From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Apr 2005 17:31:03 +0200
thanks Tom
so it is not possible to do this in one shut ?
> ____________________________________________________
> Philippe Nguyen
> CETELEM - Administration, Architecture Décisionnelle
> Direction Customer Relationship Management
> E-Mail : philippe.nguyen@xxxxxxxxxx
> Tel : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88
>
-----Message d'origine-----
De : Mercadante, Thomas F (LABOR)
[mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Envoyé : mercredi 27 avril 2005 17:27
À : 'philippe.nguyen@xxxxxxxxxx'; oracle-l
Objet : 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@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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
