3°³¿ù ÀÌÀü Åð»çÀÚ µ¥ÀÌÅÍ »èÁ¦Çϱâ
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2009-06-22 18:13:44
 

delete from tb_bi_user
where user_id IN (
select a.user_id from tb_bi_user a, ssouser.ssomng_view b
where a.user_id=b.sa_user and b.sa_temp_date <= to_char(add_months(sysdate ,-3),'yyyymmdd') and b.sa_temp='71');


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦