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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with sql-query

Re: Help with sql-query

From: <sybrandb_at_hccnet.nl>
Date: Fri, 22 Jun 2007 07:35:17 +0200
Message-ID: <kpnm73dh8u2far2mjmq1rcdl2nqv7cnhtc@4ax.com>


On Thu, 21 Jun 2007 15:02:29 -0000, Matt T <puskas.duck_at_gmail.com> wrote:

>Ugly code alert - and wouldn't want to debug that.
>
>Surely the elegant (well designed!) solution is a calendar_dates
>table.....

If you want to clutter your database with redundant rubbish, by all means do, but your so-called 'solution' isn't elegant at all, Charles' solution s. Your solution is NOT well designed! and just a *kludge*

Ever heard of pipelined functions?

-- 
i
Sybrand Bakker
Senior Oracle DBA
Received on Fri Jun 22 2007 - 00:35:17 CDT

Original text of this message

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