Re: create table with null value
From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 20 Feb 2003 18:22:44 GMT
Message-ID: <MPG.18bebccddfb17fab9896be_at_news.la.sbcglobal.net>
Date: Thu, 20 Feb 2003 18:22:44 GMT
Message-ID: <MPG.18bebccddfb17fab9896be_at_news.la.sbcglobal.net>
spribetich_at_auchan.com said...
> > 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.
>
I understand what you want. But what if the sql syntax doesn't allow you to do what you want? You could always rewrite Oracle's parser, but I suspect the separation of CREATE TABLE and INSERT INTO would be much easier. :)
-- /Karsten DBA > retired > DBAReceived on Thu Feb 20 2003 - 19:22:44 CET