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?!

You are correct. And you might safely assume that any competent DBA is going to refuse to accept such sloppy coding during a code review.

The fact that too few DBAs are competent and/or that too few code reviews take place does not alter the argument.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)