ITPub博客

DBMS_LOB.READ, REGEXP_REPLACE 读取CLOB里的信息.[@more@]set serveroutput on;SET LINESIZE 150spool /tmp/info_cache_report.csv;DECLAREv_clob CLOB;v_data VARCHAR2(1000);v_buffer INTEGER;v_audit_string VARCHAR2(1000);v_audit_date DATE;v_audit_version VARCHAR2(1000);v_trade_type VARCHAR2(1000);v_sub_type VARCHAR2(1000);BEGINDBMS_OUTPUT.PUT_LINE('QUEUE_info_ID,info_IDENTIFIER,AUDIT_VERSION,TRADE_TYPE,EXTRACTED_IND,COB_DATE,AUDIT_TIMESTAMP,ENTRY_TIMESTAMP,info_SIZE,DELAY_SECONDS');for i in (select * fro

转: http://www.itpub.net/viewthread.php?tid=955209&extra=&page=1对Hash Join的一次优化[@more@]对Hash Join的一次优化前两天解决了一个优化SQL的case，SQL语句如下，big_table为150G大小，small_table很小，9000多条记录，不到1M大小hash_area_size, sort_area_size均设置足够大，可以进行optimal hash join和memory sortselect /*+ leading(b) use_hash(a b) */ distinct a.IDfrom BIG_TABLE a, SMALL_TABLE bwhere (a.category = b.from_cat or a.category2 = b.from_cat) and a.site_id = b.site_id and

http://www.EffortlessEnglishClub.com[@more@]