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_at_cetelem.fr
> Tel : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88
>

-----Message d'origine-----
De : Alfonso León [mailto:aleon68_at_gmail.com] Envoyé : mercredi 27 avril 2005 17:39
À : philippe.nguyen_at_cetelem.fr
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_at_cetelem.fr> 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