oracle中巧妙SQL语句

--创建全局临时表
declare v_CreateTemp varchar2(2000);       
v_CreateTemp:='CREATE GLOBAL TEMPORARY TABLE TEMP_TB as
    select * from DataTB where rownum=0;';
 EXECUTE IMMEDIATE v_CreateTemp;

--将A.ID=B.ID的B表中几个字段更新到A表中   
UPDATE TestAA A
SET (A.TestName,A.A01,A.A02) =
(SELECT B.TestName,B.A01,B.A02
  FROM TestTB B WHERE A.id=B.id
) where A.ID in(SELECT D.ID FROM TestTB D);

--取相同记录中最新的记录
select A.* from A where not exists（
    select 1 from B where A.id=B.id and A.tlastupdatedate<B.tlastupdatedate）;

 

--查询两日期相关的月份数

select months_between(date'2014-04-23',date'2013-04-22') from dual