Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 11g new features

Re: Oracle 11g new features

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 29 Mar 2007 21:46:58 +0800
Message-ID: <460BC352.868@yahoo.com>


Michel Cadot wrote:
>
> "Valentin Minzatu" <valentinminzatu_at_yahoo.com> a écrit dans le message de news:
> 1174678564.142225.239690_at_n76g2000hsh.googlegroups.com...
> |
> | I bet there won't be something like:
> | SELECT * EXCEPT (col1, col2, col2) -- select all columns except
> | (col1, col2, col2)
> | FROM table_with_43_columns; -- which I'd love, but yet have to live
> | without it:)
>
> I hope this will never happen.
> I wish there was never "select *" or insert without column list.
>
> Regards
> Michel Cadot

What's wrong with

insert into table values x%rowtype

I quite like that "no column" syntax.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Thu Mar 29 2007 - 08:46:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US