改为: SELECT t.* FROM (select * from TABLE1) t order by t.C1 ASC
SQL*Plus: Release 8.1.6.0.0 - Production on 星期一 8月 15 11:22:09 2005(c) Copyright 1999 Oracle Corporation. All rights reserved. 连接到: Oracle8 Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - ProductionSQL> SELECT a.* FROM (select keshi_id from com_ksb order by keshi_id ASC) a 2 ; SELECT a.* FROM (select keshi_id from com_ksb order by keshi_id ASC) a * ERROR 位于第 1 行: ORA-00907: 缺少右括号
SELECT t.* FROM (select * from TABLE1) t order by t.C1 ASC
连接到:
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - ProductionSQL> SELECT a.* FROM (select keshi_id from com_ksb order by keshi_id ASC) a
2 ;
SELECT a.* FROM (select keshi_id from com_ksb order by keshi_id ASC) a
*
ERROR 位于第 1 行:
ORA-00907: 缺少右括号