ORA-00920

Error: ORA-00920: invalid relational operator

Causa: A search condition was entered with an invalid or missing relational operator.

Acción: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.

COMENTARIOS:

por Anónimo | 23/05/2007 22:12:55

RE: ORA-00920

como se puede solucionar:
select a.numero_contrato, a.numero_anexo, s.id_servicio, s.version
from anexo a , servicio s
where (a.numero_contrato, a.numero_anexo) in (302215,17)
and (s.id_servicio, s.version) in (20000025579,4)
and a.numero_contrato = s.numero_contrato
order by a.numero_contrato, a.numero_anexo, s.id_servicio
Gracias

por Anónimo | 16/08/2007 23:22:27

RE: ORA-00920

ORA-00920

por alfonso | 11/10/2010 20:33:18

RE: ORA-00920

select "NOTICIAS"."COD-NOTICIAS" as "COD-NOTICIAS",
"NOTICIAS"."C-USUARIO" as "C-USUARIO",
"NOTICIAS"."FECHA-PUBLICACION" as "FECHA-PUBLICACION",
"NOTICIAS"."TITULAR" as "TITULAR",
"NOTICIAS"."BAJADA" as "BAJADA",
"NOTICIAS"."CUERPO" as "CUERPO",
"USUARIO"."NOMBRE" as "NOMBRE",
"USUARIO"."PERFIL" as "PERFIL",
"USUARIO"."ESTADO" as "ESTADO"
from "USUARIO" "USUARIO",
"NOTICIAS" "NOTICIAS"
where "NOTICIAS"."C-USUARIO"="USUARIO"."COD-USUARIO"
and "USUARIO"."COD-USUARIO=1"

por seco | 08/02/2011 16:19:27

RE: ORA-00920

select ename,deptno,hiredate
from emp
where deptno=10 and hiredate '01/01/1981' and '31/12/1981';

por David | 09/02/2011 00:57:32

RE: ORA-00920

Prueba con between
select ename,deptno,hiredate
from emp
where deptno=10 and hiredate between '01/01/1981' and '31/12/1981';