摘要：
create table page as select * from dba_objects; create index idx_page on page(object_id);create index idx_page_1 on page(owner,object_id);create index... 阅读全文
摘要：
SELECT * FROM (SELECT pubformdat0_.id id332_, pubformdat0_.domain_id domain2_332_, pubformdat0_.process_id process3_332_, ... 阅读全文
摘要：
create table test1 as select * from dba_objects;create table test2 as select * from dba_objects;create unique index test1_idx1 on test1(object_id);sel... 阅读全文
摘要：
今天在做mkdir操作时报错：Invalid file system control data detected。检查用户和权限没问题，再检查磁盘空间也没问题。最后在网上找到如下信息：【problem】# mkdir aaamkdir: 0653-358 Cannot create aaa.aaa:... 阅读全文
摘要：
spawn rsync -avH --delete /home/dwetl/bin dwetl@10.128.8.151:/home/dwetl/binsending incremental file listbin/bin/ftpgj.logbin/ftpjx.logbin/perl_add_gm... 阅读全文
摘要：
drop table test1;create table test1 as select * from dba_objects where rownum 'SCOTT', tabname => 'TEST1', ... 阅读全文
摘要：
sar -P ALL -u 阅读全文
摘要：
select * from test a where object_id in (select department_id from hr.dept_1 dept where department_id IN (select department_id from hr.employees_... 阅读全文
摘要：
FILTER的适用范围:1. 主表返回的记录数较少2.子查询返回记录数较小下面做实验证明:select department_name from hr.dept_1 dept where department_id IN (select department_id from hr.employee... 阅读全文
摘要：
包用于逻辑组合相关的过程和函数,它由包规范和包体两部分组成,包规范用于定义公用的常量变量,过程和函数,在SQL*PLUS中建立包规范可以使用CREATE PACKAGE命令。实例如下:CREATE OR REPLACE PACKAGE emp_pkg IS PROCEDURE update_... 阅读全文