Display query results like \G in MySQL when using Oracle / sqlplus?
Posted
by jed79
on Stack Overflow
See other posts from Stack Overflow
or by jed79
Published on 2010-03-30T14:40:28Z
Indexed on
2010/03/30
14:43 UTC
Read the original article
Hit count: 346
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?
© Stack Overflow or respective owner
