ORA-00905:缺少关键字错误oracle [英] ORA-00905: missing keyword error oracle

问题描述

当我尝试执行以下oracle查询时，我得到

Hi when i am trying to execute following oracle query I am getting

[Err] ORA-00905:缺少关键字

[Err] ORA-00905: missing keyword

CREATE VIEW MJNSXJJRW_view AS  
SELECT B.oID AS "_oid", B.oTm AS "_otm" 
FROM 
(SELECT DISTINCT oID, oTm FROM MJNSXJJRW) B 
LEFT JOIN MJNSXJJRW AS S0 ON 
    B.oID = S0.oID AND 
    S0.idx = 0 AND 
    S0.kID = "str_val" ; 

推荐答案

最可能的问题是MJNSXJJRW AS S0.定义列别名时使用AS关键字，而不是定义表别名时使用.

The most likely issue is MJNSXJJRW AS S0. You use the AS keyword when defining column aliases, not when defining table aliases.

CREATE VIEW MJNSXJJRW_view AS  
SELECT B.oID AS "_oid", B.oTm AS "_otm" 
FROM 
(SELECT DISTINCT oID, oTm FROM MJNSXJJRW) B 
LEFT JOIN MJNSXJJRW S0 ON 
    B.oID = S0.oID AND 
    S0.idx = 0 AND 
    S0.kID = "str_val" ; 

我假设"str_val"是一列，而不是字符串文字.如果是后者，则应使用单引号.

I'm assuming that "str_val" is a column, not a string literal. If it's the latter you should use single quotes.

这篇关于ORA-00905:缺少关键字错误oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！