Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Timeout any SQL?
It is possible and highly desirable to do it. If u have luck your Interrupt character(typically ^c) will do it. Else if u are in unix issue a "kill <pid>" .
-=[ CE Raymond ]=- <kp1wong_at_cs.hku.hk> wrote in article
<55pi5g$6iv_at_ns.cs.hku.hk>...
> Hello all!
>
> If I submitted a SQL statement which listed out the join of all tables in
> my view, is it possible to "kill" the query if the Oracle server not
> returned the result in a certain period of time?
>
> Best regards,
> Raymond
>
Received on Tue Nov 12 1996 - 00:00:00 CST