I understand that read committed option is set for transaction level to get the committed data before the current query is executed. I have a question, may be a dumb question
Let us say, I have a session set as
ALTER SESSION SET ISOLATION_LEVEL READ COMMITTED;
but I have a procedure created in the same session which includes the statement
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
how does that procedure execute, does it go by READ COMMITTED or SERIALIZABLE ?
Kindly suggest !