If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
Hi Everyone,
i am new to DB & DBForums.i am working on a DB2-Oracle migration project. as part of it, i need the SQL Equivalent of the below DB2 statements :
1.SET PATH &
2.SET CURRENT ISOLATION
can some one please help me with this?
2. ALTER SESSION SET ISOLATION_LEVEL = READ COMMITTED
1. DB2 SET PATH allows you to specify the search order of schema names when using unqualified functions and types. However, Oracle resolves schemas differently, see here: Syntax for Schema Objects and Parts in SQL Statements
__________________
Florin Aparaschivei
Iasi, Romania