Re: Speaking of New Features

From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 9 Sep 2009 21:00:06 -0500
Message-ID: <bc04324b0909091900u3ac794d9h33d2f36b61701f2a_at_mail.gmail.com>



You may be appealing to the wrong people. The SQL 92 standard specifies the INSERT statement syntax (page 388 of
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt). However, I suppose it's always possible to create "extensions" to those standards too.

Dan

On Wed, Sep 9, 2009 at 8:37 PM, chet justice <chet.justice_at_gmail.com> wrote:

> Any thoughts on the "new" syntax for INSERT statements below?
>
> INSERT INTO my_table
> ( id => seq.nexval,
> create_date => SYSDATE,
> update_date => SYSDATE,
> col1 => 'A',
> col2 => 'SOMETHING',
> col3 => 'SOMETHING',
> col4 => 'SOMETHING',
> col5 => 'SOMETHING',
> col6 => 'SOMETHING',
> col7 => 'SOMETHING',
> col8 => 'SOMETHING',
> col9 => 'SOMETHING',
> col10 => 'SOMETHING',
> col11 => 'SOMETHING',
> col12 => 'SOMETHING',
> col13 => 'SOMETHING',
> col14 => 'SOMETHING' );
>
> Thought of one day while trying to clean up (make human readable) someone
> else's code. I would either get too many values or not enough. After
> copying the INSERT columns and subsequent VALUES clause into an Excel
> spreadsheet to compare them side by side, I thought, hey, what about named
> notation?
>
> Anyway, I created the "Idea" on Oracle Mix here<https://mix.oracle.com/ideas/94278-position-insert-syntax>if you are inclined to, one way or another, to vote.
>
> chet
>
> --
> chet justice
> www.oraclenerd.com
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 09 2009 - 21:00:06 CDT

Original text of this message