摘要： 1 、重新启动oracle2 、Network/admin目录下找到listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\Oracle10g) (PROGRAM = extproc) )============ 加入================ (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E:\Oracle10g) //路径同上 (SID_NAME = ORCL) )============ . 阅读全文

摘要： select * from (select b.*,rownum a from (select * from 表名) b)where a between 5 and 10; 阅读全文