Delete records between two rownum range
558940Jun 22 2007 — edited Jun 22 2007Hi frnds,
I have a problem to delete records between two ronum range.
i executed the sql like
"Delete from Sales where rownum > 500 and rownum <600 order by salesdate"
when i executed this query i am getting 0 records deleted. But the table contains more than 5000 records,
My requirement is, i want to delete the rows between 500 to 600 in order by sales date.
regards,
dhaya.