Re: Are one row, one column tables "acceptable"?

"Thomas T" <T_at_T> wrote in message news:3e9467ad$3_at_rutgers.edu...
> Niall, I just tried it... although I used svrmgrl instead of sqlplus. I
> thought I'd enter an infinite loop; I didn't expect to see one row of 4
> columns! I think I need to do some studying of the dual table! I even
did
> "desc dual"; never tried that before, either.

He he. Fun isn't it?

I think that my serious point was that although 1 row, 1 col tables are "acceptable", valid uses of them tend to be 'really' special cases. Not 'special cases' which end up in every implementation known to Man. 'dual' is very clearly a special case not a model for good practice. Also its fun - did I mention that?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************