Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Saving a constant into the Oracle schema?

Re: Saving a constant into the Oracle schema?

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 02 Apr 2003 19:09:23 GMT
Message-ID: <3E8B3471.91971CC7@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 Received on Wed Apr 02 2003 - 13:09:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US