Skip to Main Content
Forums

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!

How to delete data from a table within a date range

Sai Kumar Araboina-OracleOct 18 2019 — edited Oct 19 2019

Hi team,

Can you please help me with a query to delete data from the table with in a date range.

Here is the query that I was able to write. Pls correct or suggest a proper query.

Delete HA_HC_BOOKS_MATRICS
where MONTH = TO_DATE('10/15/2017', 'MM/DD/YYYY') BETWEEN  TO_DATE('12/15/2017', 'MM/DD/YYYY')

Regards,

Sai Kumar
Comments
Post Details
Added on Oct 18 2019
8 comments
10,860 views