Re: no exec

A copy of this was sent to "stef_pellegrino" <stef_pellegrino_at_hotmail.com> (if that email address didn't require changing) On Fri, 1 Jun 2001 14:19:07 +0200, you wrote:

>Hi everybody,
>
>Does a "no exec on" of sybase exist under oracle ?
>
>(Under sybase "no exec on" is used to test only a query, not execute it)
>
>Under oracle I've tried SET AUTOTRACE TRACEONLY, but failed
>
>got an idea ?
>
>
>thanx
>
>see you...
>

explain plan will tell you want a query does without doing the query.

http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/ch4i30.htm#4212

the traceonly of autotrace actually executes the query and fetches all of the rows -- it just doesn't print them out. It shows you what the query will do in real life without taking the time to scroll the screen....

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp