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!

ORA-00933-while delete the records in the table

selvi mOct 8 2021

Hi All
while execute the below query that thrown an error like -0rq-00933(-inner-join-ora-00933-sql-command-not-properly-ended)
can you please help how to handle this scenario

Delete from final_ord a
inner join final_old b
on(a.order_num=b.order_num and a.inv=b.inv)
where date_submit<(current_date-b.din_days);

This post has been answered by BluShadow on Oct 8 2021
Jump to Answer
Comments
Post Details
Added on Oct 8 2021
4 comments
1,375 views