Java.sql.sqlsyntaxerrorexception: ora-00936: missing expression la gi

INSERT INTO T_VEHICULO VALUES (29122,'','',,,'','', '',,,,,TO_NUMBER(''),TO_NUMBER(''), TO_NUMBER(''),TO_NUMBER(''),TO_NUMBER(''),TO_NUMBER(''),'',,,'','','',TO_NUMBER(''))

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'

por lvlr | 27/06/2008 16:38:17

RE: ORA-00936

"INSERT INTO SERVICIO VALUES
(
SQ_SERVICIO.NEXTVAL,
UPPER('".$_POST["nombre"]."'),
'".$_POST["precio"]."',
'".$_POST["tragos"]."',
'".$_POST["descripcion"]."',
'".$_POST["tipo"]."',

)"

por anim | 30/09/2008 08:02:09

RE: ORA-00936

SQL> select clientes.codigo_empresa, clientes.nombre, provincias.provincia, provincias.nombre from c
lientes, provincias, albaran_ventas where albaran_ventas.ejercicio = 2007 and albaran_ventas.ejercic
io = 2006 order by;

por FFF | 14/09/2009 14:41:49

RE: ORA-00936

INSERT INTO rcc_reportes (codigo_reporte,nombre,descripcion, id_tipo_reporte )
VALUES (rcc_s_reporte.nextval,
'REPORTE TOTAL DE LICENCIAS',
'Reporte de total de licencias en AXIS',
SELECT (R.id_tipo_reporte)COD_REPORTE FROM rcc_tipo_reporte R
WHERE R.nombre = 'REPORTES - CORREO ELECTRONICO');

por FFF | 14/09/2009 14:46:35

RE: ORA-00936

INSERT INTO rcc_reportes (codigo_reporte,nombre,descripcion, id_tipo_reporte )
VALUES (rcc_s_reporte.nextval,
'REPORTE TOTAL DE LICENCIAS',
'Reporte de total de licencias en AXIS',
SELECT (R.id_tipo_reporte)COD_REPORTE FROM rcc_tipo_reporte R
WHERE R.nombre = 'REPORTES - CORREO ELECTRONICO');

por Anónimo | 09/11/2009 01:18:55

RE: ORA-00936

CREATE TABLE "DBA1"."PRODUCT_MASTER" ( "PRODUCT_ID" NUMBER(7), "PRODUCT_NAME" VARCHAR2(50) NOT NULL , "CODE" VARCHAR2(10) NOT NULL , "REORDER_THRESHOLD" NUMBER(5), "COST" NUMBER(5), "PRICE" NUMBER(5), CONSTRAINT "PK_INV" PRIMARY KEY ("PRODUCT_ID") VALIDATE , CONSTRAINT "CHK_REORDER" CHECK (NUMBER >= 0) VALIDATE ) TABLESPACE "INVENTORY"

por jh | 17/11/2009 07:25:14

RE: ORA-00936

$sql ="INSERT INTO CENTRO_RESPONSABILIDAD (ID,CODIGO, DESCRIPCION, ACTIVO, USR_MOD, FECHA_MODIFICACION, ESTABLECIMIENTO_ID) VALUES (".NULL.",".$_POST["$ccrr_codigo"].",".strtoupper($_POST["ccrr_descripcion"]).",".$_POST["ccrr_activo"].",".$usr_id.",".date('d-m-Y').",".$estab_id.")";

About Us

We are a group of software developers.
We enjoy learning and sharing technologies.
To improve the site's content,
your valuable suggestions
are most welcome. Thanks
Email : [email protected]

Mobile Apps


SCJP Quiz


ConcretePage.com

The ORA-00936: missing expression error is related with the missing of SQL statement syntax and omitted a part of the syntax.

missing expression

If you forget to use of FROM clause or Column names in your SELECT statement, you will get this error.

To solve this error, make sure your SQL Statement or SQL Syntax is written correctly.

Check your SQL Statement, if you use extra commas, then remove it if it shouldn’t be in your query.

Don’t forget * or From clause in Select statement as follows.

Example 1:

SELECT FROM Test_table; 
ORA-00936: missing expression

Example 2:
SELECT * Test_table; 
ORA-00936: missing expression

To solve this error, use * and  from in SQL Statement as follows.

select * from Test_table;

If you got this error in Update,insert or delete statement, make sure that you have used all the keywords that are required (UPDATE, SET, VALUES, WHERE and etc..)