Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Saving a constant into the Oracle schema?
Sybrand Bakker wrote:
> On Tue, 1 Apr 2003 12:02:20 -0500, "Thomas" <T_at_T> wrote:
>
> >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
> >
>
> Just create a package with the constant declared in the package
> specification.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Or enter it into a table.
Daniel Morgan Received on Tue Apr 01 2003 - 12:49:14 CST