|
-
1.
cursor selectfordelete is select * from test where region not in ('REGROLL','WWF','WWR','CON','
3 'CAN','LATAM','OWH','REGEAST','AFRME','ASPAC','EUR','OEH','OTH','NCI','WOUS','WOUSCON') for upd
replace 'select *'
with 'select ROWID ROW_ID'
2.
delete from test where current of selectfordelete
replace 'where current of ..'
with 'where ROWID = selectfordelete.ROW_ID'
3.
commit every 100 or 1000 deletes
Hope this helps
Gert
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|