This we use for to set the session to different optimizer mode.
EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''9.2.0.8''';
If you are login a different user ['SIVA'] and want to use different schema tables [apps] instead of specifying the apps. table_name everytime we can run this command to set the current session to apps.
ALTER SESSION SET CURRENT_SCHEMA = APPS
EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''9.2.0.8''';
If you are login a different user ['SIVA'] and want to use different schema tables [apps] instead of specifying the apps. table_name everytime we can run this command to set the current session to apps.
ALTER SESSION SET CURRENT_SCHEMA = APPS
