Re: ORA-00920 invalid relational operator

olivier.duhart_at_gmail.com wrote:

> Billy : Well I absolutely don't know what a bind variable is. Could you
> explain or give a little example please ?
>
> Thanks both
>
> Olivier

That is a truly horrifying ommission given that Tom Kyte has been on a bind variable crusade for a very long time.

DECLARE
   x PLS_INTEGER := 1996;
BEGIN
   ... AND t.sgmversion = x;
END;
/

Get a copy of Tom Kyte's book "Expert one-on-one Oracle" today. You are killing scalability and performance with what you are writing. Oracle considers

AND t.sgmversion = 1996 to be a different query from
AND t.sgmversion = 1997 which is different from
AND t.sgmversion = 1998.

But AND t.sgmversion = x is always the same.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)