SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Returning multiple date columns in order

672933Jun 2 2009 — edited Jun 2 2009

Hi,

I was just wondering if there was an easy way of returning a number of date values in order at row level.

An example of the data would be:-

TABLE DATES

P1_DATE P2_DATE P3_DATE P4_DATE
01-JAN-2009 13-FEB-2008 16-JUN-1998 30-SEP-2006

The problem being that in this case I would want to return P3_DATE, P4_DATE, P2_DATE and P1_DATE in this order. However, this would not always be the case as there are no specific rules to state that P3_DATE is before P4_DATE etc.

Any help or advice you could give would be appreciated.

Regards,
ca84

This post has been answered by Frank Kulash on Jun 2 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2009

Added on Jun 2 2009

7 comments

719 views