Re: Saving a constant into the Oracle schema?

In that case, I concur with solutions suggested by Daniel & Sybrand.

Anyone considered the following variation?

1. Create a separate table to contain this value. Add an 'effective date' column in that table and then you can do secondary analysis around this effective date.
2. Use the login trigger to select the current value & place that in a context variable. Reference the context variable in your PL/SQL

/Hans Received on Wed Apr 02 2003 - 13:09:23 CST