Re: Speaking of New Features
Date: Fri, 11 Sep 2009 07:38:21 +0200
The current form could of course not be made invalid. It would cause literally every Oracle system in existence to not work on the new version.
I don\t think it means that insert would have to support positional. Oracle has frequently made improvements that just work for one thing. There are joins that only work with ansi syntax and there are tons of features that requires CBO. When it coexisted with RBO, there was never a view at Oracle that new features should work with RBO.
On Fri, Sep 11, 2009 at 1:28 AM, Michael Moore<michaeljmoore_at_gmail.com> wrote:
> 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.