04 2015 档案

sql 抓取脚本
摘要：select * from v$sql swhere s.last_active_time > (select sysdate-1/24/60/60*8 from dual) and s.last_active_time 0 and s.executions <100 and s.parsing_s... 阅读全文
posted @ 2015-04-27 12:11 朵拉.科波菲尔 阅读(273) 评论(0) 推荐(0)
Oracle Blob转Clob和Varchar2
摘要：createorreplaceFUNCTIONblob_to_clob(blob_inINBLOB)RETURNCLOBISv_clobCLOB;v_varcharVARCHAR2(4000);v_startPLS_INTEGER:=1;v_bufferPLS_INTEGER:=4000;g_nls... 阅读全文
posted @ 2015-04-07 17:33 朵拉.科波菲尔 阅读(456) 评论(0) 推荐(0)