Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00920 invalid relational operator
<olivier.duhart_at_gmail.com> wrote in message news:1120484025.720625.185130_at_o13g2000cwo.googlegroups.com... Thanks Billy and Morgan.
Morgan : This query is only an example, I generate it dynamically and
though region and holding may not be ignored in the [AND
e.region||'.'||e.subregion||'.'||e.holding LIKE '%.24.%'] part
Same remark for sgmversion and typologyversion but I should have
explained
the context of this query, shame on me.
Billy : Well I absolutely don't know what a bind variable is. Could you explain or give a little example please ?
Thanks both
Olivier
Olivier,
Read Tom Kyte's books or read the docs. (Oracle Application Developer's
Guide at otn.oracle.com) All databases that I have experience with allow
the use (and encourage) the use of bind variables, also known as host
variables or parameters to a query. (In Java usually denoted by a ?) Bind
variables are not new and not unique to Oracle.
Jim
Received on Mon Jul 04 2005 - 11:10:23 CDT
![]() |
![]() |