Re: How to Get Every two weeks settlement --allways Wednesday

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 29 Jul 2006 20:40:07 +0200
Message-ID: <eaga26$5dp$00$1@news.t-online.com>

DA Morgan schrieb:
> Charles Hooper wrote:

>> rjayanth_at_gmail.com wrote:
>>> Hi,
>>>
>>> I am trying to get solution for this. I need to get settlement every

>
> Not necessarily. Why not a pipelined table function that could
> be joined in the query (no table and no maintenance ... ever).
>
> There is a demo PTF in Morgan's Library at www.psoug.org that
> shows how one is written and used in a join.

I suggest, all more or less popular approaches to generate rows are listed here:
http://orafaq.com/wiki/Oracle_Row_Generator_Techniques

Best regards

Maxim Received on Sat Jul 29 2006 - 13:40:07 CDT