摘要:
select to_char(trunc(add_months(last_day(sysdate), -1) + 1), 'yyyy-mm-dd') "本月第一天",to_char(last_day(sysdate), 'yyyy-mm-dd') "本月最后一天"--Oracle trunc()函数...
阅读全文
posted @ 2014-05-20 10:24
huak
阅读(9198)
推荐(0)
编辑
摘要:
SELECT a.sid, a.serial#, b.sql_text FROM v$session a, v$sqltext bWHERE a.sql_address = b.address AND a.sid = &sidORDER BY b.piece
阅读全文
posted @ 2014-05-20 10:16
huak
阅读(149)
推荐(0)
编辑