Re: Speaking of New Features

From: Ahbaid Gaffoor <ahbaid_at_att.net>
Date: Sat, 12 Sep 2009 08:04:21 -0700
Message-ID: <4AABB875.3010805_at_att.net>

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

Received on Sat Sep 12 2009 - 10:04:21 CDT