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!

display records in day wise

KPRAug 5 2010 — edited Aug 11 2010

Dear All,

I have 100 records in my table with doj date field. I have to display the records like day wise. By default in Oracle day start with sunday. I need to display records like

Note : - only in a single select query...!!

datefields sunday
datefields monday
datefields tuesday
datefields wednesday
datefields thursday
datefields friday
datefields saturday
datefields sunday
datefields monday
datefields tuesday
datefields wednesday

Please advise.....!!!

Regards
Prabhu.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2010

Added on Aug 5 2010

#date

5 comments

1,410 views