Re: Speaking of New Features
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Sep 2009 16:28:12 -0700
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
Other related posts:
