查询三个月以内的数据
select * from CostRequest where 1=1 and DATEDIFF(CURDATE(),costRequestDate)<90
SELECT PUBDATE from t_iw_doc where PUBDATE>="TO_DATE"('2016-10-01', 'yyyy-mm-dd')
多表更新
update T_MM_MEETING a set a.MEETINGROOMID = (select b.MEETINGROOMID from T_MM_MEETINGROOM b
where A .AUDITOPINION = b.MEETINGROOMADDR)
where A .MEETINGROOMID IS NULL ;
SELECT ADD_MONTHS(sysdate, -12) AS "当前时间减一年" FROM dual;
查看数据库哪些表被锁住
select b.owner,b.object_name,a.session_id,a.locked_mode
from v$locked_object a,dba_objects b
where b.object_id = a.object_id