ORA-00923
Error: ORA-00923: FROM keyword not found where expected
Causa: In a SELECT or REVOKE statement, the keyword FROM was either missing, misplaced, or misspelled. The keyword FROM must follow the last selected item in a SELECT statement or the privileges in a REVOKE statement.
Acción: Correct the syntax. Insert the keyword FROM where appropriate. The SELECT list itself also may be in error. If quotation marks were used in an alias, check that double quotation marks enclose the alias. Also, check to see if a reserved word was used as an alias.
COMENTARIOS:
por El rey de los errores | 08/03/2007 17:45:54
RE: ORA-00923
No hay respuesta?????
por David | 10/11/2010 05:25:03
RE: ORA-00923
Pon la query que te da problemas. Así podremos averiguar qué pasa. Seguramente sea un problema de sintaxis. Una coma de más?
por Cristobal Garcia | 09/12/2014 19:47:09
RE: ORA-00923
en esta consulta cuando lo ejecuto en asp me genera error
SELECT RPPPF__CODIGO____B AS RUBRO,RPPPF__NOMBRE____B AS DESC_RUBRO
FROM RPPPF_
WHERE
SUBSTR(RPPPF__CODIGO____B,1,1) IN (SELECT DISTINCT SUBSTR(APPRCU_CODIGO____RPPPF__B,1,1) RUBRO1
FROM RPPPF_, APPRCU WHERE RPPPF__CODIGO____B= APPRCU_CODIGO____RPPPF__B
AND RPPPF__CODIGO____PF_____B= '2014'
AND APPRCU_CODIGO____PF_____B = '2014'
AND APPRCU_CODIGO____CONTAB_B = 'CORP'
AND APPRCU_CODIGO____PP_____B = 'PPTO'
AND APPRCU_CODIGO____TP_____B IN ('EG','SE')
AND APPRCU_CODIGO____CU_____B = UPPER('C04013'))
AND RPPPF__CODIGO____PF_____B='2014'
AND LENGTH(TRIM(RPPPF__CODIGO____B))= 6
GROUP BY RPPPF__CODIGO____B, RPPPF__NOMBRE____B
gracias a quien me pueda ayudar.