Re: Speaking of New Features

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Sat, 12 Sep 2009 20:43:31 +0200
Message-ID: <ecf3dae70909121143l3b42ba34oea7d1f1758a169cb_at_mail.gmail.com>



>
> In tables with hundres of columns named ATTR_001 thru ATTR_500 it is really
> painful to write a select for all but the last two columns.
>

Wow.
Someone did a real good relational database design there :-)

On Sat, Sep 12, 2009 at 5:04 PM, Ahbaid Gaffoor <ahbaid_at_att.net> wrote:

> Chet, I like it. Building on your suggestion:
>
> What I'd also like to see is the following additions to the SELECT
> statement
>
> --
> -- Select all columns except those listed
> --
> SELECT * EXCEPT ATTR_005, ATTR_007 from my_table;
>
> --
> -- Select columns that match an expression
> --
> SELECT * WHERE COLUMNS LIKE 'ATTR%' OR 'DATE%' from my_table;
>
>
> In tables with hundres of columns named ATTR_001 thru ATTR_500 it is really
> painful to write a select for all but the last two columns.
>
> regards
> Ahbaid
>
> chet justice 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.oraclenerd.com>
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 12 2009 - 13:43:31 CDT

Original text of this message