with t as(select date'2019-1-1'+level-1 dt from dual connect by level<=365)select dt,to_char(dt,'w')w,to_char(dt,'day') d,trunc((to_char(dt,'dd')+to_char(last_day(ad
select bh.*,h4.* from bh,h4 where bh.aspdm=h4.h4spdm and bh.ajiage!=h4.h4jiageupdate bh set ajiage=(select h4jiage from h4 where h4spdm=bh.aspdm) where aspdm in (SELECT h4spdm FROM h4)