> : And your comment about parameterized views is preposterous on its face.
> : Explore, for example, the numerous examples everywhere on the use of the
> : SYS_CONTEXT built-in function.
>
> Well, a very useful looking function - there's always something to learn.
>
> I note that that function is not listed in the index of my copy of
> "Oracle8i The Complete Reference", from Oracle Press, written by Kevin
> Loney and George Koch, or in the indexes of any of the other books from
> oracle press that are on our book shelves here.
>
> May I at least assume therefore that this function must be relatively new?
>
If I'm not mistaken it was introduced in 8.1.6, as well as CREATE CONTEXT
DDL command. So it's not really new. In 9i Rel.2 contexts were enhanced
and now you can have global contexts shared between sessions (you could
only have session contexts until then.)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Thu Jan 30 2003 - 11:51:50 CST
