How to Get Every two weeks settlement --allways Wednesday

From: <rjayanth_at_gmail.com>
Date: 28 Jul 2006 10:17:00 -0700
Message-ID: <1154107019.851697.185240@s13g2000cwa.googlegroups.com>

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 Received on Fri Jul 28 2006 - 12:17:00 CDT