Error ORA-00936
Descripción: missing expression
Causa: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.
Acción: Check the statement syntax and specify the missing component.
COMENTARIOS:
por Anónimo | 04/04/2007 17:47:34
RE: ORA-00936
INSERT INTO T_VEHICULO VALUES (29122,'','',,,'','', '',,,,,TO_NUMBER(''),TO_NUMBER(''), TO_NUMBER(''),TO_NUMBER(''),TO_NUMBER(''),TO_NUMBER(''),'',,,'','','',TO_NUMBER(''))
por Anónimo | 11/04/2007 7:10:44
RE: ORA-00936
sdsdsds
por Carmina | 07/04/2008 17:21:32
RE: ORA-00936
SELECT GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, CC.ID_CENTRO_COSTOS, CC.DS_CENTRO_COSTOS, GI.MONTO, RB.ID_TIPO_RUBRO, GI.ID_MES, '1' Orden
FROM (REN_C_RUBROS RB INNER JOIN REN_F_GASTO_INGRESO GI ON RB.ID_RUBRO=GI.ID_RUBRO) INNER JOIN REN_C_CENTRO_COSTOS CC ON GI.ID_CENTRO_COSTOS=CC.ID_CENTRO_COSTOS
WHERE GI.ID_MES=1 AND GI.ID_AÑO=2008
UNION
SELECT GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, '0', 'Mes anterior', SUM(GI.MONTO), RB.ID_TIPO_RUBRO, GI.ID_MES, '2' Orden
FROM (REN_C_RUBROS RB INNER JOIN REN_F_GASTO_INGRESO GI ON RB.ID_RUBRO=GI.ID_RUBRO) INNER JOIN REN_C_CENTRO_COSTOS CC ON GI.ID_CENTRO_COSTOS=CC.ID_CENTRO_COSTOS
WHERE GI.ID_MES=1 AND GI.ID_AÑO=2007
GROUP BY GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, '0', 'Mes anterior', RB.ID_TIPO_RUBRO, GI.ID_MES, '2'
UNION
SELECT GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, '0', 'Variación', SUM(GI.MONTO), RB.ID_TIPO_RUBRO, 0, '3' Orden
FROM (
SELECT GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, SUM(GI.MONTO), RB.ID_TIPO_RUBRO,
FROM (REN_C_RUBROS RB INNER JOIN REN_F_GASTO_INGRESO GI ON RB.ID_RUBRO=GI.ID_RUBRO) INNER JOIN REN_C_CENTRO_COSTOS CC ON GI.ID_CENTRO_COSTOS=CC.ID_CENTRO_COSTOS
WHERE GI.ID_MES=1 AND GI.ID_AÑO=2008
GROUP BY GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, RB.ID_TIPO_RUBRO
UNION
SELECT GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, SUM(GI.MONTO*-1), RB.ID_TIPO_RUBRO,
FROM (REN_C_RUBROS RB INNER JOIN REN_F_GASTO_INGRESO GI ON RB.ID_RUBRO=GI.ID_RUBRO) INNER JOIN REN_C_CENTRO_COSTOS CC ON GI.ID_CENTRO_COSTOS=CC.ID_CENTRO_COSTOS
WHERE GI.ID_MES=1 AND GI.ID_AÑO=2008
GROUP BY GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, RB.ID_TIPO_RUBRO
)
GROUP BY GI.ID_AÑO, RB.NO_NIVEL, RB.DS_RUBRO1, '0', 'Variación', RB.ID_TIPO_RUBRO, 0, '3'
