Hi All
I am very new to database stuff.Please ignore if I am wrong.Is there a possiblity to write a script in oracle which deletes the rows from a table based on the age. i.e., I want to delete the rows which are >120 days. I have a table with millions of rows in it and I want to keep only the latest 4 months rows. I have the following table with column names as
ERROR_IND
FEED_ID
QUEUE_ID
FEED_DT_TM...
rthota211
Last Activity: Jan 20 '12, 07:55 PM
Joined: Jan 16 '12
Location:
-
Script to delete rows in a table and partition of the table
-
Script to delete rows from a table
Hi All,
Is there a possiblity to write a script in oracle which deletes the rows from a table based on the age.i.e., I want to delete the rows which are >120 days . I have a table with millions of rows in it and I want to keep only the latest two months rows. I have the following table with column names as ERROR_IND
FEED_ID
QUEUE_ID
FEED_DT_TM
I have written "delete * from tablename where...
No activity results to display