Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Support for external pager

user7543419Jan 4 2019 — edited Jan 7 2019

How do I get results sent to an external pager command (such as less/more)?

If there is currently no way to do this, I'd like to make this a feature request.

Being able to navigate/search query results with an external pager is a very useful thing and support for this should be a basic feature in my opinion.

Thanks.

Comments

Gaz in Oz

I achieve similar functionality via spool to a file and use my favourite text editor, vi (vim).

SQL> set _editor=vim

SQL> spool a_file.txt

SQL> select col1, ...coln from a_table where...

SQL> spool off

SQL> ed a_file.txt

...

user7543419

I though of that, but really?  What a pain to have to do something like that around every query!  BTW instead of 'ed a_file.txt' I'd probably use 'ho less a_file.txt;rm a_file.txt'.

1 - 2

Post Details

Added on Jan 4 2019
2 comments
163 views