Re: using a variable as a "macro"

[Quoted] On Fri, 16 Dec 2005 07:34:21 -0800, cumin wrote:

> Is there a way to access an environmental variable in sqlplus? A lot of
> the ad hoc queries I run have the phrase
>
> and tty in ('IN','BN','SCD','SBD','SCDF','SBDF','SCDC','SBDC')
>
> and I am too lazy to type that in so much. Is there a way to set and
> retrieve a string variable in sqlplus that will let mr put this string
> into numerous queries? I'd like the vairable to live in the databse,
> but if it needs to be an OS environent variable that's ok too.
>
> Thanks

How about looking up 'substitution variables' in the docco. Or are you too lazy for that as well? Received on Fri Dec 16 2005 - 22:33:06 CET