hello, i have this query, it works in Oracle 9 and 8 but not works in oracle 7, appears an Oracle: ORA-00907: missing right parenthesis error in the line where the CASE begins....

some help???

select o.identificacion,
count (*) envios,
count (c.rtado_presentacion) colocaciones,

(case
      when (count (c.rtado_presentacion))>= 1
      then min (c.cno_oferta)
end) cnoCol1,

(case
      when (count (c.rtado_presentacion))>= 1
      then substr (min (c.cno_oferta),1,1)
end) area1col1,

(case
      when (count (c.rtado_presentacion))>= 1
      then substr (min (c.cno_oferta),2,1)
end) nivel1col1,

(case
      when (count (c.rtado_presentacion))>= 2
      then max (c.cno_oferta)
end) cnocol2,

(case
      when (count (c.rtado_presentacion))>= 2
      then substr (max (c.cno_oferta),1,1)
end) areacol2,

(case
      when (count (c.rtado_presentacion))>= 2
      then substr (max (c.cno_oferta),2,1)
end) nivelcol2

from cruce c, ofertas o
where o.fecha_inscripcion >= '01/01/2004'
and o.fecha_inscripcion <= '09/30/2004'
and c.identificacion_oferta = +o.identificacion
group by o.identificacion
order by colocaciones

The operator "CASE ... " is not supporting in Oracle 7x.

ok.... ¿ another operator does not exist who can replace the operator CASE in Oracle 7.x ??

I think you can use DECODE for 7.x. I'm not 100% sure.

You can use the DECODE operator in Oracle 7x.

i have 2 tables apple a and banana b

if a.pineapple= "p" then display "a.first_name" and 'a.last_name"
if a.pineapple = "O" then display "b.code"

can any one hlp me to write the selct statements

How can learn Oracle, DBA, SQL and total management. Please help

use DECODE for 7.x.