Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with sql-query
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 DBAReceived on Fri Jun 22 2007 - 00:35:17 CDT