Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Declare Global Variables
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:19:19 CDT
![]() |
![]() |