Re: iterating over SYS_CONTEXT?
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 9 May 2009 08:00:23 +0200
Message-ID: <4a051bf6$0$5913$426a34cc_at_news.free.fr>
Date: Sat, 9 May 2009 08:00:23 +0200
Message-ID: <4a051bf6$0$5913$426a34cc_at_news.free.fr>
<mh_at_pixar.com> a écrit dans le message de news: 3x3Nl.29417$Ws1.3130_at_nlpi064.nbdc.sbc.com...
| 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
For predefined USERENV context, afaik, no.
For your own custom context, yes:
have a look at v$context and v$globalcontext
Regards
Michel
Received on Sat May 09 2009 - 01:00:23 CDT