Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

djberg96 (2603)

djberg96
  (email not shown publicly)

Journal of djberg96 (2603)

Thursday October 28, 2004
10:18 AM

Explain your Oracle SQL

[ #21568 ]
I was just glancing at the docs for the recent release of DBD::Oracle (1.16), when I noticed that it comes with a handy little Tk based explain tool.

If you've installed DBD::Oracle, then you can simply type "ora_explain" and a nice little Tk interface pops up where you can enter your sql, hit the "explain" button, and an explain plan appears at the top, with an explanation in the middle. There are some other options, too.

Handy tool to have if you don't happen to have TOAD or TORA. :)

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.