ITPub博客

The measurement of duplicate is the values of two or more records for columns(prod_id,cust_id,time_id) are the same. select prod_id,cust_id,time_id,channel_id,promo_id,quantity_sold,amount_sold from (...

select grp, dbms_rowid.rowid_create( 1, data_object_id, lo_fno, lo_block, 0 ) min_rid, dbms_rowid.rowid_create( 1, data_object_id, hi_fno, hi_block, 10000 ) max_rid from (select disti...

$ impdp system/cloudwave1 schemas=icopy directory=dir_dump file=icopy20120619.dmp执行到一半，由于机器要做性能测试，所以暂停任务。按CTRL+C之后输入Import> stop_job退回到控制台。当需要继续运行impdp时...

create table testchar(c1 char(10));insert into testchar(c1) values('a');--没有空格select * from testchar where c1='a'--有一个空格select * from testchar where c1='a ';--多于10个空格select * from testch...