Re: Saving a constant into the Oracle schema?

From: Jérôme VUIBERT <jerome.vuibert_at_fleximage.fr>
Date: Wed, 2 Apr 2003 09:32:02 +0200
Message-ID: <3e8a91f4$0$30758$626a54ce@news.free.fr>

You can also make a function that gives you the value, as a method in OOP. Then this value can be stored in a table, as a constant in a package and so on.

Jerome

"Thomas" <T_at_T> a écrit dans le message de news: 3e89c82b$1_at_rutgers.edu...
> Hello; I'd like to save a constant value into the Oracle schema. The
value
> gets changed mid-year, and isn't based on the date. Is there a way to
save
> this value? I have programs into which I'm either hardcoding the value,
or
> referencing the registry, or basing the value on something in the record.
> Basically I'd like to do the following:
>
> Current- save the value "34J9" into the database.
> This November- save the value "35J9" into the database
> Next November- save the value "35K0" into the database
>
> Besides SQL*PLUS, I use VB6 w/ADO, VC++ 6 with OLE-DB 2.0, and IIS 5/ASP
> with custom COM components.
>
> Thanks!
>
> -T
>
>
Received on Wed Apr 02 2003 - 01:32:02 CST