Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Would be really nice if...
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 BortelReceived on Thu Feb 24 2005 - 07:50:11 CST