ORA-00933
Error: ORA-00933: SQL command not properly ended
Causa: The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order.
Acción: Correct the syntax by removing the inappropriate clauses. It may be possible to duplicate the removed clause with another SQL statement. For example, to order the rows of a view, do so when querying the view and not when creating it. This error can also occur in SQL*Forms applications if a continuation line is indented. Check for indented lines and delete these spaces.
COMENTARIOS:
por pablo | 25/10/2007 17:31:56
RE: ORA-00933
puede tener paretecis de mas
por JOHN | 05/05/2008 21:59:44
RE: ORA-00933
BUENAS TARDES,TENGO UN PROBLEMA CON ESTE ERROR,CUANDO QUIERO INSERTAR VARIAS FILAS DE DATOS A UNA TABLA DE MI BD; CON EL COMANDO INSERT PRIMERO LE COLOQUE PUNTO Y COMA Y SALIA EL ERROR ORA 00911; BORRE EL PUNTO Y COMA Y FUNCIONO PARA UNA FILA PERO PARA VARIAS SALE EL ERROR ORA 00933 Y SOLAMENTE CON COMA TAMPOCO FUNCIONA... YUDEN POR FA YA NO SE QUE MAS PROBAR
por LEO | 25/01/2010 08:43:34
RE: ORA-00933
SELECT A.NUM_IDENT,C.des_valor
FROM GE_CLIENTES A ,GA_VALOR_CLI B,GE_VALORES_CLI C
WHERE A.COD_CLIENTE = B.COD_CLIENTE
AND B.COD_VALOR = C.COD_VALOR
AND A.NUM_IDENT in ('10241715-8')
AND A.cod_tipident IN ('03','04')
CASE C.DES_VALOR WHEN 'EMPRESAS BV' THEN 'PYMES'
AYUDA POR FA