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');
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.

Other related posts: