Is there a way to delete more than 1 record at a time? I'm
using oracle 8 and CF 4.5. I need to delete several records at once but haven't found a way to do it. If I just do more than 1 delete "query" it times out. I need to do something like this: delete from my_table where id = '1', where id = '2', where id = '5'. This however doesn't work either.
Oracle says that the query is not properly ended. I've tried puttting a ; at the end but that doesn't work either. Any thoughts?
using oracle 8 and CF 4.5. I need to delete several records at once but haven't found a way to do it. If I just do more than 1 delete "query" it times out. I need to do something like this: delete from my_table where id = '1', where id = '2', where id = '5'. This however doesn't work either.
Oracle says that the query is not properly ended. I've tried puttting a ; at the end but that doesn't work either. Any thoughts?