Re: Variable where clause

Alan Davey's solution is perfect for me. Thanks a lot, Alan.=20

Regards, Ranko.=20

On 6/15/05, Jared Still <jkstill_at_gmail.com> wrote:
> Thanks Ian, that is probably a better solution.
>=20
> Right now though, it's too late, and I am too tired to follow it. :)
> I'll try again tomorrow.
>=20
> That, and my PL/SQL skills are still mostly Oracle 7. =20
>=20
> Jared
>=20
>=20
>=20
> On 6/14/05, MacGregor, Ian A. <ian_at_slac.stanford.edu> wrote:
> > It is not readily apparent that this method is applicable to the proble=
m,
> and I deleted the original message. Variable where clauses can be handle=
d
> through sys_context. See
> http://asktom.oracle.com/pls/ask/f?p=3D4950:8:::::F4950_P8_DISPLAYID:1288=
401763279
> >=20
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > ian_at_slac.stanford.edu
> >=20
> >=20
>=20
>=20
> --=20
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist=20
>=20
>

--
http://www.freelists.org/webpage/oracle-l