Re: about CTAS and column definition
- From: Alfonso León <aleon68@xxxxxxxxx>
- To: philippe.nguyen@xxxxxxxxxx
- Date: Wed, 27 Apr 2005 10:38:47 -0500
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 :
>=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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Alfonso Leon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
