Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
when i ran query i got error . plz help me to resolve isssue
ORA-30926: unable to get a stable set of rows in the source tables
Merge into val_1 vv
(select trade_1, val_1 from temp_1 where flag=1)x on (x. val_1 =vv.val_1)
when matched then update
Sorry - wrong forum!
This forum is ONLY for Sql Developer questions.
Please mark the thread ANSWERED and repost it in the SQL and PL/SQL forum.
Before you repost search the forum and you will find MANY threads that have already answered that same question.
Just search the net for 'oraclel sql forum stable set of rows'