Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL* plus alternative

Roger22Mar 11 2014 — edited Mar 14 2014

Hello,

I'm looking for a tool which replaces SQL* plus. In Oracle Database 11, the SQL plus can be accessed just from a command line window. What other tool can be used as a replacement for SQL Plus (and which works with all sql plus commands, because SQL Developer does not support all of the comands), and which automatically generates the explain plan after a statement has been executed?

When posting SQL statements to this forum, what tool are you using to format the explain plan as being readable (i saw some posts in which explain plan was well-ordered and readable, other posts where it was so unclear (the column headers were on different position than the values).

For me, using SQL plus from command line it's not so pleasant.

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2014
Added on Mar 11 2014
70 comments
4,920 views