朵拉.科波菲尔

摘要： Oracle和mysql的一些简单命令对比 1)　SQL> select to_char(sysdate,'yyyy-mm-dd') from dual; SQL> select to_char(sysdate,'hh24-mi-ss') from dual; mysql> select d... 阅读全文

摘要： 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... 阅读全文

摘要： createorreplaceFUNCTIONblob_to_clob(blob_inINBLOB)RETURNCLOBISv_clobCLOB;v_varcharVARCHAR2(4000);v_startPLS_INTEGER:=1;v_bufferPLS_INTEGER:=4000;g_nls... 阅读全文