Re: Speaking of New Features

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 11 Sep 2009 09:58:35 -0700
Message-ID: <bf46380909110958q445ff18bm6385dec333dff98b_at_mail.gmail.com>

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_at_gmail.com>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_at_gmail.com> 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_at_gmail.com>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_at_optimaldba.com
>>> > 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_at_dwf10gr2> insert into t2
>>>> 2 values ( /* c1 */ 12,
>>>> 3 /* c2 */ 42
>>>> 4 )
>>>> 5 /
>>>>
>>>> 1 row created.
>>>>
>>>> Post-column
>>>> DEMO_at_dwf10gr2> insert into t2
>>>> 2 values ( 12, -- c1
>>>> 3 42 -- c2
>>>> 4* )
>>>> DEMO_at_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_at_eds.com>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_at_freelists.org [mailto:
>>>>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jared Still
>>>>> *Sent:* Thursday, September 10, 2009 12:04 PM
>>>>> *To:* chet.justice_at_gmail.com
>>>>> *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_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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> chet justice
>>>> www.oraclenerd.com
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> chet justice
>>> www.oraclenerd.com
>>>
>>>
>>
>
>
> --
> chet justice
> www.oraclenerd.com
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 11 2009 - 11:58:35 CDT