Support for external pager

user7543419

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.

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'.