摘要：
产生ora-01653表空间扩展失败的过程： DBF放在Ｅ盘且Ｅ盘只有剩余的２００Ｍ --1.建表 DROP TABLE bigtab; CREATE TABLE bigtab AS SELECT rownum as "id", a.* FROM dba_objects a; DRO... 阅读全文
摘要：
SQL> drop user lisi;drop user lisiORA-01940: 无法删除当前连接的用户SQL> select username,sid,serial# from v$session where username is not null;USERNAME ... 阅读全文
摘要：
SQL> drop user lisi;drop user lisiORA-01940: 无法删除当前连接的用户SQL> select username,sid,serial# from v$session where username is not null;USERNAME ... 阅读全文
摘要：
SQL> drop user lisi;drop user lisiORA-01940: 无法删除当前连接的用户SQL> select username,sid,serial# from v$session where username is not null;USERNAME ... 阅读全文
摘要：
select * from (select * from aaa.computers order by comNo) where rownum<=x;(x代表要取得前多少行) 阅读全文
摘要：
select * from (select * from aaa.computers order by comNo) where rownum<=x;(x代表要取得前多少行) 阅读全文
摘要：
select * from (select * from aaa.computers order by comNo) where rownum<=x;(x代表要取得前多少行) 阅读全文
摘要：
create table computers（ comNo number(4) constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price n... 阅读全文
摘要：
create table computers（ comNo number(4) constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price n... 阅读全文
摘要：
create table computers（ comNo number(4) constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price n... 阅读全文