ORA-00905:缺少关键字错误oracle | 缺少关键字错误oracle

本文介绍了ORA-00905:缺少关键字错误oracle的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

当我尝试执行以下.

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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！