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!

I need to display the last 7 days as rows in oracle use this as a join to other table to get a resul

Rajesh Arumugam SelvarajDec 18 2015 — edited Dec 19 2015

I need to display the last 7 days as rows in oracle.

col1

sysdate

sysdate-1

sysdate-6

I need to use this and join with other table to make a single record available for each row in the table against a particular day.

Table Products

Result:

P1 sysdate

P2 sysdate

P3 sysdate

P1 sysdate - 1

...

P3 sysdate - 6

Thanks,
Rajesh A S

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2016

Added on Dec 18 2015

#plsql

6 comments

7,669 views