Assuming 8.1+, your most efficient option
may be to investigate sys_context and
database logon triggers.
--
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
Steven Pannell wrote in message <9kopsn$5kote$1_at_ID-82797.news.dfncis.de>...
>Hi everyone,
>
>I am wondering if it is possible to define a global varaible such that is
it
>available in all functions and can be used in my SQL statements. For
>example I would like to do this:
>
>CONSTANT monday = 1;
>
>
>The run a select statement as:
>
>SELECT * FROM myTable WHERE dayfield = monday
>
>is this at all possible?
>
>Thanks in advance,
>Steve
>
>
Received on Tue Aug 07 2001 - 08:46:39 CDT
