常用SQL语句

update

(

select /*+BYPASS_UJVC*/ e.num,f.cnum

from

(  select num,website_id,areaid,stat_time from adt_click_hour_website

   where stat_time<to_date(to_char(sysdate-1/24,'yyyy-MM-dd HH24:') || '00:00','yyyy-mm-dd HH24:MI:ss')

   and stat_time>=to_date(to_char(sysdate-2/24,'yyyy-MM-dd HH24:') || '00:00','yyyy-mm-dd HH24:MI:ss') 

)e,

(

   select areaid,website_id,stat_time,cnum from hour_website_pv 

   where stat_time<to_date(to_char(sysdate-1/24,'yyyy-MM-dd HH24:') || '00:00','yyyy-mm-dd HH24:MI:ss')

   and stat_time>=to_date(to_char(sysdate-2/24,'yyyy-MM-dd HH24:') || '00:00','yyyy-mm-dd HH24:MI:ss')

)

f

where e.stat_time=f.stat_time and e.website_id=f.website_id and e.areaid=f.areaid

) g

set g.cnum=g.num;

commit;

and s.last_call_date<sysdate-7

select Segment_Name,Sum(bytes)/1024/1024||' MB' ,tablespace_name
From User_Extents Group By Segment_Name,tablespace_name order by Sum(bytes)/1024/1024 desc

group by to_char(t.add_time, 'yyyy-mm-dd HH24')
order by to_char(t.add_time, 'yyyy-mm-dd HH24')
to_char(stat_time,'yyyy-mm-dd HH24')='2008-03-28 08'
to_date('2008-03-21 11:05:05','yyyy-mm-dd-hh24:mi:ss')

ANALYZE TABLE hour_adv_url ESTIMATE STATISTICS SAMPLE 10 PERCENT;

purge recyclebin;
                                                              
substr(web_type, 0, 3) = a.website_type_id
to_char(stat_time, 'YYYY-MM-DD')
to_char( wpp.pay_time,'yyyy-mm-dd')='2008-04-28'

select wpp.owner_id from v_web_owner wpp
having count(*)>1 group by wpp.owner_id

truncate table log_web_webid