Re: about CTAS and column definition

From: Alfonso León <aleon68_at_gmail.com>
Date: Wed, 27 Apr 2005 10:38:47 -0500
Message-ID: <83a585ac05042708385e9bc014@mail.gmail.com>

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 :

>=20


> SQL> desc A

> Name   Type      Nullable Default Comments

> ------ --------- -------- ------- --------
> NUMCLI NUMBER(3) Y

>=20

> SQL> create table B as select sum(ctas.numcli) as numcli from A;

>=20

> Table created

>=20

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

>=20
> In table B, how can I make column numcli have number(3) type not just num=
ber
> column definition using "Create Table As Select" method ? Is it possible =
?

>=20

> TIA
> Philippe

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Alfonso Leon

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

Received on Wed Apr 27 2005 - 11:43:05 CDT