答复: Delete Data older than exactly 2 years

From: "jametong" <jametong@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 20 Apr 2007 10:15:28 +0800

date_col <= add_months(sysdate,-24)
 

Jametong


DBA Team. B2B. 阿里巴巴中国

----------------------------
Phone   : 0571-85022088-12372
Fax     : 0571-85022958
Mobile  : 135-8803-9828
Mail    : jame.tongjw@xxxxxxxxxxxxxxx
          jametong@xxxxxxxxx
Msn     : kt_tongjiawang@xxxxxxxxxxx
Yahoo   : jametong
Alitalk : jametong
Skype   : jametong
-----------------------------


 

  _____  

发件人: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 代
表 Sanjay Mishra
发送时间: 2007年4月20日 9:08
收件人: oracle-l@xxxxxxxxxxxxx
主题: Delete Data older than exactly 2 years


Hi 
 
Can somebody suggest good method to delete all record older than 2 years from
the current date. This script will run on the last sunday of each month. I will
write the logic for Last sunday in Unix shell but need some idea about the SQL.
I can't use some 365+366 or so kind of logic. THis is 9i.
 
TX
Sanjay


  _____  

Ahhh...imagining that irresistible "new car" smell?
Check out new
<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3o
DMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM-> cars at
Yahoo! Autos.

References:

Delete Data older than exactly 2 years
From: Sanjay Mishra

答复: Delete Data older than exactly 2 years

Other related posts: