oracle - 为什么会出现 "missing right parenthesis"错误？

Question

为什么查询会产生此错误？

ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"

select * from
(
  (select * from dual) alias1,

  (select * from dual) alias2
)

我在 10g 和 11g 上出现错误

Answer 1

SQL 语法不正确。删除外圆括号，如下所示:

select * from 
(select * from dual) alias1, 
(select * from dual) alias2;