Cancelling a long running query

Hi,

I am trying to break a long running query by hitting ctrl+c. It works fine giving me a ora-1013.

I am using a long running insert (inserting about 100000 records) before I hit ctrl + c. I do this just to make sure I have enough time before issuing ctrl + c.( I also need to do this becase I might issue the ctrl+c programatically using threads, where one thread issues the DML and the second thread issues a ctrl+c, because the second thread needs sufficient time to cancel out the first before the first finishes executing )

I want to replace this long running DML query with a simple select from a table (say EMP joined with DEPT, which must take long time to finish executing or should never return)

Can someone please suggest me how I could write a query which executes continously (or recursively, to never return), using a table like EMP (or EMP joined with DEPT if necessary).

Rgds. Received on Wed Nov 02 2005 - 00:52:16 CST