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: How to Get Every two weeks settlement --allways Wednesday

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

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Fri, 28 Jul 2006 19:44:59 +0200
Message-ID: <44ca4d19$0$164$a3f2974a@nnrp1.numericable.fr>


rjayanth_at_gmail.com wrote:
> Hi,
>
> I am trying to get solution for this. I need to get settlement every
> two weeks and it alwyas happens on "Wednesday"
>
> Example :To Day's Date Jul 19
>
> My output look like this
>
> Date Day
>
> Jul19 Wed
> Aug 2 Wed
> Aug 16 Wed
> Aug 30 Wed
> ....so on till End Date which is 30 years
>
> Kindly let me know ASAP
>
> Oracle Version:Oracle 9i, restriction no PL/SQL
>
>
> Regards
> Jay
>

It's not comprehensible. Restate it differently and give at least your tables description. Received on Fri Jul 28 2006 - 12:44:59 CDT

Original text of this message

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