Display query results like \G in MySQL when using Oracle / sqlplus?
- by jed79
In MySQL, you can use \G to run a query:
select * from mytable\G
And your results will be displayed in an inverted table, kinda 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 any way to get a similar format using Oracle / sqlplus?
