RE: about CTAS and column definition

sorry Alfonso : 
SQL> create table C as select cast(sum(ctas.numcli) as number(3)) as numcli
from A;

Table created

SQL> desc C
Name   Type   Nullable Default Comments 
------ ------ -------- ------- -------- 
NUMCLI NUMBER Y        

> ____________________________________________________
> 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 : Alfonso León [mailto:aleon68@xxxxxxxxx]
Envoyé : mercredi 27 avril 2005 17:39
À : philippe.nguyen@xxxxxxxxxx
Cc : oracle-l
Objet : Re: about CTAS and column definition


create table B as select cast(sum(ctas.numcli) as number(3)) as numcli from
A

On 4/27/05, NGUYEN Philippe (Cetelem) <philippe.nguyen@xxxxxxxxxx> wrote:
> 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
> 


-- 
Alfonso Leon

--
http://www.freelists.org/webpage/oracle-l

Other related posts: