Re: table containing the days for a week

> May work.
>
> SQL> select count(*) from user_objects;
>
> COUNT(*)
> ----------
> 1
>
> May not.
>

Well, obviously it's something you need to design to use a table which has at least 7 rows. It's a solution for pre 9i.

> It would certainly be much more inefficient.
>
> --
> MJB
>

True, it does more i/o and can run out of rows, but for 7 days it's hardly inefficient.

Kevin Received on Wed Apr 27 2005 - 01:47:02 CDT