is "dual" table locked during transaction if SQL statement uses "dual"
If we have a Oralce merge statement like this:
merge into table_a A using (select 10 as ID, 'John' as Name from dual) B on (A.ID=B.ID)
when matched then update set A.Name=B.Name
when not matched then insert (ID, Name) values(B.ID, B.Name)
When this statement is executed, is the "dual" table locked?
Thanks
gary