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: Would be really nice if...

Re: Would be really nice if...

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 24 Feb 2005 14:50:11 +0100
Message-ID: <cvklug$5g2$1@news5.zwoll1.ov.home.nl>


kirtan wrote:
> Using the same logic,
> 'select * from t' would also break any application if an alter table
> has been done to it.
> This would happen where the columns are being retrieved by position and
> not by name.
> But ain't this feature still there?!
>

Correct - it is known as A Bad Habit (tm). ROT: Always specify the column list.

-- 
Regards,
Frank van Bortel
Received on Thu Feb 24 2005 - 07:50:11 CST

Original text of this message

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