Package Constants vs Literals

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   Received on Thu Oct 19 2006 - 14:38:30 CDT