liaoya的专栏

Update SQLS will lead dead lock exception. Because by default, it use optimistic lock but not pessimistic lock.Below description is exceprted from the attachment(It exceeds my image that this blog

1. Use the clob to concatenate the sql string.2. Use DBMS_SQL to execute SQL.

Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

-- check the block running sqlselect sid,serial#,sql_id,blocking_session,username from v$session where blocking_session>0; -- find the current running sqlSELECT OSUSER,SERIAL#,SQL_TEXT