Skip to Main Content

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!

Print the count based sysdate

RengudiJan 9 2023

Hi Guru,
Great day is today.
I want to print out the count based filter in where clause

select count(*) from mytable where SYS_CREATED_ON > SYSDATE-&N;

here, N -> number of days before. Let say 3; 

What I want 
SYS_CREATED_ON           CNT
10_JAN_2023              210524
09_JAN_2023              112568
08_JAN_2023              546783

Thanks

This post has been answered by mathguy on Jan 9 2023
Jump to Answer
Comments
Post Details
Added on Jan 9 2023
3 comments
447 views