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