玩转Oracle第3讲

 

 

 

 

 

update emp set (job,sal,comm)=(select job,sal,comm

from emp where ename=‘SMITH’) where ename=‘SCOTT’;

 

 

 

 

 

 

 

 

 

 

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

    SET TRANSACTION READ ONLY;

--设置整个会话的隔离级别

 ALTER SESSION SET ISOLATION_LEVEL SERIALIZABLE;

    ALTER SESSION SET ISOLATION_LEVEL READ COMMITTED;