SELECT COLUMN_NAME,DATA_TYPE,DATA_LENGTH,NVL(DATA_PRECISION,0) FROM SYS.ALL_TAB_COLUMNS WHERE OWNER = 'PAPER' AND TABLE_NAME = 'ATTACHMENTS' ORDER BY COLUMN_NAME
SELECT COLUMN_NAME FROM SYS.ALL_IND_COLUMNS WHERE INDEX_NAME IN (SELECT INDEX_NAME FROM SYS.ALL_INDEXES WHERE UNIQUENESS = 'UNIQUE' AND TABLE_OWNER = 'PAPER' AND TABLE_NAME = 'ATTACHMENTS')
SELECT COLUMN_NAME FROM SYS.ALL_IND_COLUMNS WHERE INDEX_NAME IN (SELECT INDEX_NAME FROM SYS.ALL_INDEXES WHERE UNIQUENESS = 'UNIQUE' AND TABLE_OWNER = 'PAPER' AND TABLE_NAME = 'ATTACHMENTS')
Cause: The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify values to compare because the subquery returned more than one row.
Action: Use ANY, ALL, IN, or NOT IN to specify which values to compare or reword the query so only one row is retrieved.
楼主是2个SQL 一起运行的? 单个运行可行?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
在每个sql后面都加分号;,然后扔到sqlplus里去,。