oracle - 如何解决ORA 00936缺少表达式错误？

Question

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。请帮我

注意：:: rrfh表不包含任何数据。

Answer 1

删除逗号？

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子句
名称