Tuesday, October 14, 2008

SYS_CONTEXT

Sys_Context funtion used to retrieve information about the oracle environment.

Syntax:

sys_context(namespace, parameter, [length])

  • NAMESPACE is an oracle namespace that has alrady been created.
  • PARAMETER is valid attribute that has been set using the DBMS_SESSION.set_context procedure.
  • length is optional. It is the length of the return value in bytes.


For more and example Click Here


No comments: