Re: Speaking of New Features
From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Thu, 10 Sep 2009 16:28:12 -0700
Message-ID: <26fdee6e0909101628g3483fdfdu192a4bb361dc6821_at_mail.gmail.com>
If it was as chet suggested, then how could you do
Date: Thu, 10 Sep 2009 16:28:12 -0700
Message-ID: <26fdee6e0909101628g3483fdfdu192a4bb361dc6821_at_mail.gmail.com>
If it was as chet suggested, then how could you do
insert into t (a,b) select x,y from r;
It would mean you would need to have two valid syntaxes for the INSERT.
1.) insert into t(a,b) values ('a','b');
and
2) insert into t (a => 'a', b=>'b');
both would need to be valid. Not that that is a terrible thing but if you are going to have both 'named' and 'positional' for INSERT, then you would probably want both forms available for UPDATE as well. Mike
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 10 2009 - 18:28:12 CDT