How to run a query in PL/SQL with Serializable transaction isolation

0 votes

1 answer

992 views

oracle oracle-11g transaction isolation-level plsql-developer

                          I want to run this SQL in Oracle 11g:

    declare a number;
      begin 
      select count(*) into a  from item w where w.Item_num='MOH601' ; 
      dbms_output.put_line(a);
      end ; 

How to run this query with isolation Serializable? As I have learnt before, Oracle will lock the rows with w.Item_num='MOH601' when using Serializable.

                        

Asked by Mohammad Mirzaeyan (117 rep)

Sep 15, 2016, 07:09 AM
Last activity: Apr 24, 2020, 10:03 AM

How to run a query in PL/SQL with Serializable transaction isolation

Related Questions