How do I query the state of a session variable in PL / SQL?

Question

I see that in PL / SQL it is possible to set the session state of a specific variable for the rest of the session lifetime. For example:

ALTER SESSION SET CURRENT_SCHEMA=<schema>

How do I query the current state of this schema so that I can revert to it after some other statements have been executed?

+1

Jordan parmer 12 nov. '08 at 20:07

1 answer

Justin cave · Accepted Answer · 2008-11-12T20:11:00+0000

SELECT SYS_CONTEXT( 'USERENV', 'CURRENT_SCHEMA' ) FROM dual;