如何解决ORA 00936缺少表达式错误? [英] How to resolve ORA 00936 Missing Expression Error?
本文介绍了如何解决ORA 00936缺少表达式错误?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Select /*+USE_HASH( a b ) */ to_char(date, 'MM/DD/YYYY HH24:MI:SS') as LABEL,
ltrim(rtrim(substr(oled, 9, 16))) as VALUE,
from rrfh a, rrf b,
where ltrim(rtrim(substr(oled, 1, 9))) = 'stata kish'
and a.xyz = b.xyz
上述查询的"from"(第三行)部分给了我ORA-00936 Missing EXPRESSION error
.请帮助我
The "from " (3rd line) part of the above query is giving me ORA-00936 Missing EXPRESSION error
. Please Help me
注意 :: rrfh表中没有数据.
NOTE :: rrfh table contains no data.
推荐答案
删除逗号?
select /*+USE_HASH( a b ) */ to_char(date, 'MM/DD/YYYY HH24:MI:SS') as LABEL,
ltrim(rtrim(substr(oled, 9, 16))) as VALUE
from rrfh a, rrf b
where ltrim(rtrim(substr(oled, 1, 9))) = 'stata kish'
and a.xyz = b.xyz
看看 FROM
从多个表中进行选择您可以在 通过列出表并在每个表之间加逗号来表示FROM子句 名称
SELECTING from multiple tables You can include multiple tables in the FROM clause by listing the tables with a comma in between each table name
这篇关于如何解决ORA 00936缺少表达式错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文