Display query results such as \ G in MySQL when using Oracle / sqlplus?

Question

In MySQL, you can use \ G to run a query:

select * from mytable\G 

And your results will appear in an inverted table, like this:

 *************************** 1. row *************************** column1: 12345 another_colum: another value yet_another: ABCD *************************** 2. row *************************** column1: 238479 another_colum: another value again yet_another: WXYZ 

Is there a way to get a similar format using Oracle / sqlplus?

Answer 1

There is a utility called Tom Kyte, created under the name print_table , which does roughly the same thing.