Christy H. wrote:If this closes the issue, I would suggest you to close the Thread by marking it as "Answered".
Edited by: Christy H. on Jan 17, 2013 1:58 AM
I removed ON DELETE CASCADE and ran againWow deleted!!
delete from news where TO_CHAR(news_date,'YYYY') < 2008;
This forum is miracle to learn oracle. Thanks from the bottom of my heart