Just tried to add a comment, and the Mix site is currently brokenand not allowing comments to be added. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On Thu, Sep 10, 2009 at 4:17 PM, chet justice <chet.justice@xxxxxxxxx>wrote: > Just don't forget to vote for it (either way): > https://mix.oracle.com/ideas/94278-position-insert-syntax > > :) > > > On Thu, Sep 10, 2009 at 7:07 PM, Jared Still <jkstill@xxxxxxxxx> wrote: > >> Not just ugly, it's harder to read. >> Specifying name/value pairs in INSERT statements would >> be a huge improvement. >> >> Jared Still >> Certifiable Oracle DBA and Part Time Perl Evangelist >> >> >> >> On Thu, Sep 10, 2009 at 11:45 AM, chet justice <chet.justice@xxxxxxxxx>wrote: >> >>> True, that would work. It's just ugly though...in my opinion anyway. :) >>> >>> >>> On Thu, Sep 10, 2009 at 2:38 PM, Daniel Fink <daniel.fink@xxxxxxxxxxxxxx >>> > wrote: >>> >>>> In the absence of actual implementation, comments are your friend. Why >>>> not use comments to indicate which column you are referencing? Granted it >>>> does not totally address the situation of specifying a limited number of >>>> columns or and independent order, but it would help when inserting 100 >>>> columns or so. >>>> >>>> Pre-column >>>> DEMO@dwf10gr2> insert into t2 >>>> 2 values ( /* c1 */ 12, >>>> 3 /* c2 */ 42 >>>> 4 ) >>>> 5 / >>>> >>>> 1 row created. >>>> >>>> Post-column >>>> DEMO@dwf10gr2> insert into t2 >>>> 2 values ( 12, -- c1 >>>> 3 42 -- c2 >>>> 4* ) >>>> DEMO@dwf10gr2> / >>>> >>>> 1 row created. >>>> >>>> Regards, >>>> Daniel Fink >>>> >>>> -- >>>> Daniel Fink >>>> >>>> OptimalDBA http://www.optimaldba.com >>>> Oracle Blog http://optimaldba.blogspot.com >>>> >>>> Lost Data? http://www.ora600.be/ >>>> >>>> >>>> >>>> >>>> >>>> chet justice wrote: >>>> >>>> I think I would require the use of the correct column name instead of >>>>> any type of positional col-n style labeling. >>>> >>>> >>>> Agreed. That was just an example, those are the actual column names. >>>> >>>> >>>> On Thu, Sep 10, 2009 at 1:47 PM, Powell, Mark D <mark.powell@xxxxxxx>wrote: >>>> >>>>> Well, the suggested syntax below would make matching up a long column >>>>> list to the provided values/variables a lot easier and would likely help >>>>> prevent listing 100 columns to be inserted but only including 99 variables >>>>> in the values list. I think I would require the use of the correct column >>>>> name instead of any type of positional col-n style labeling. >>>>> >>>>> -- Mark D Powell -- >>>>> Phone (313) 592-5148 >>>>> >>>>> >>>>> ------------------------------ >>>>> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >>>>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jared Still >>>>> *Sent:* Thursday, September 10, 2009 12:04 PM >>>>> *To:* chet.justice@xxxxxxxxx >>>>> *Cc:* oracle-l >>>>> *Subject:* Re: Speaking of New Features >>>>> >>>>> Very Perlish. >>>>> I like it. :) >>>>> >>>>> Jared Still >>>>> Certifiable Oracle DBA and Part Time Perl Evangelist >>>>> >>>>> >>>>> >>>>> On Wed, Sep 9, 2009 at 6:37 PM, chet justice >>>>> <chet.justice@xxxxxxxxx>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 >>>>>> >>>>>> >>>>> >>>> >>>> >>>> -- >>>> chet justice >>>> www.oraclenerd.com >>>> >>>> >>>> >>> >>> >>> -- >>> chet justice >>> www.oraclenerd.com >>> >>> >> > > > -- > chet justice > www.oraclenerd.com > >