Re: how to browse all sys_context(...) values?
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 12 Apr 2010 16:44:28 -0800
Message-ID: <4bc3b05c$1_at_news.victoria.tc.ca>
Frank Bergemann (FBergemann_at_web.de) wrote:
: Hi,
: is there a way to browse all e.g. sys_context(USER, <xy>) elements (or
: sys_context('USERENV', <xy> elements) and displaying their values - w/
: o knowing up-front, which <xy> are there?
: - thanx!
: cheers,
: Frank
Date: 12 Apr 2010 16:44:28 -0800
Message-ID: <4bc3b05c$1_at_news.victoria.tc.ca>
Frank Bergemann (FBergemann_at_web.de) wrote:
: Hi,
: is there a way to browse all e.g. sys_context(USER, <xy>) elements (or
: sys_context('USERENV', <xy> elements) and displaying their values - w/
: o knowing up-front, which <xy> are there?
: - thanx!
: cheers,
: Frank
select * from session_context;
(Depending on your database version of course.) Received on Mon Apr 12 2010 - 19:44:28 CDT