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 + readline library + pager

551707Dec 20 2006 — edited Dec 20 2006
Hi,

I am relatively new to Oracle and therefore I would like to know why SQL*Plus command line utility is so spartan and user unfriendly.

I am talking about SQL*Plus 10.2.0.1 included in Oracle 10g R2 for Linux x86. On many UNIXes platforms there are readline library and pager utility for output piping. Typical example of user-friendly command line utility is MySQL client. So, my question is:

why is SQL*Plus binary different (not linked against readline library and doesn't provide a call to pager for output piping)?

Thanks

Albert

Comments

247514
Frankly, that's question to Oracle development team

SQL*Plus has been around for a long time. There's no major overhaul to this application during all these years and I didn't think Oracle plan to do that in future.

A lot of features you mentioned are already available in sqlplus
If Mysql client can satisfy you so should sqlplus.
There are many setting you can use to achieve the output format you like.

For example,

COL <column_name> FORMAT a<integer>
SET LINESIZE,
PAGESIZE,
PAUSE,
etc, etc
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 17 2007
Added on Dec 20 2006
1 comment
522 views