Re: Package Constants vs Literals

klabu wrote:
> select *
> from sometable
> where somecol = 'SOMECODE'
> and someothercol = 'SOME_OTHER_CODE'
> and someothercol2 = some_numeric_code
>
>
>
> Is this a "good" thing (meaning NO performance impact) to do:
> If those "CODES" have a finite set of values..
> create a package and put those values in constants
> and replace those literals in the SQL with the package constants ?
>
> thanks

See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7832114438832 to see how to figure out if it works for your exact code. Especially note the first and Sept. 13, 2006 responses.

jg

-- 
@home.com is bogus.
http://www.drivemeinsane.com/