Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: create table with null value

Re: create table with null value

From: Séb <spribetich_at_auchan.com>
Date: Thu, 20 Feb 2003 17:52:22 +0100
Message-ID: <b330bv$2jm$1@reader1.imaginet.fr>


> Try
> create table toto2 as select col1, col2, col3 from toto where 1=2;
> insert /*+ APPEND */ into toto2 select col1, col2, NULL from toto;
> --

No I don't want to make an insert, because I have many many tables with many many columns. Received on Thu Feb 20 2003 - 10:52:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US