is there a way to iterate over the information in SYS_CONTEXT()?
i.e. I don't want to have a huge

select sys_context('USERENV', 'foo'), sys_context('USERENV','bar'),
etc...

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

mh (AT) pixar (DOT) com wrote:
: is there a way to iterate over the information in SYS_CONTEXT()?
: i.e. I don't want to have a huge

: select sys_context('USERENV', 'foo'), sys_context('USERENV','bar'),
: etc...


select * from session_context;

<mh (AT) pixar (DOT) com> a écrit dans le message de news: 3x3Nl.29417$Ws1.3130 (AT) nlpi064 (DOT) nbdc.sbc.com...
For predefined USERENV context, afaik, no.
For your own custom context, yes:
have a look at v$context and v$globalcontext

Regards
Michel