ITPub博客

--查询Oracle正在执行的sql语句及执行该语句的用户SELECT b.sid oracleID,         b.username 登录Oracle用户名,         b.serial#,       &...

select d.status, d.tablespace_name,TO_CHAR(NVL(a.bytes / 1024 /1024, 0),'99G999G990') "size(M)",TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0),0)/1024/1024, '99G999G990D00') used,TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes* 100, 0), '990D00')||'%' pctFROM sys.dba_tablespacesd,(s...

select next_day(to_date('2016-06-01','yyyy-mm-dd')+(level-1)*7,2)from dualconnect by next_day(to_date('2016-08-01','yyyy-mm-dd')+(level-1)*7,2) <= to_date('2017-12-31','yyyy-mm-dd')