Re: Saving a constant into the Oracle schema?

From: Thomas T <T_at_T>
Date: Sat, 5 Apr 2003 22:47:12 -0500
Message-ID: <3e8fa340$1@rutgers.edu>

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news:3E8B3471.91971CC7_at_telusplanet.net...
> 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
>

Hans, thanks for the tip! I never thought of using the login triggerinteresting solution! Thanks!

-Thomas Received on Sat Apr 05 2003 - 21:47:12 CST