Re: Like operator and Parameter
From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 23 Apr 2005 01:36:07 GMT
Message-ID: <Xns9640BD3ACD728SunnySD_at_68.6.19.6>
Date: Sat, 23 Apr 2005 01:36:07 GMT
Message-ID: <Xns9640BD3ACD728SunnySD_at_68.6.19.6>
"OraRepDvlpr" <itsashok_at_gmail.com> wrote in news:1114208034.007157.35620_at_z14g2000cwz.googlegroups.com:
> Hi group,
> I am new to oracle reports and currently going thru the learning
> curve. I need to use a parameter in Parameter Form in SQL clause.
>
> SELECT a,b,c from TD where TD.e like '%'||:p_from_Form||'%'
>
> The above SQL does not work.
> Any idea
>
>
Yes, your post makes NO sense,
Do you have any idea how many different ways "SQL does not work"
might occur?
You're On Your Own (YOYO)!
P.S.
Do some research on dynamic SQL and/or EXECUTE IMMEDIATE
Received on Sat Apr 23 2005 - 03:36:07 CEST