Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: table containing the days for a week

Re: table containing the days for a week

From: Kevin Crosbie <caoimhinocrosbai_at_yahoo.com>
Date: Wed, 27 Apr 2005 08:47:02 +0200
Message-ID: <1114584454.0a6fdd576149621390c90238413e8c67@teranews>

> 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

Original text of this message

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