Re: Vertical align columns in sql*plus

  • From: John Piwowar <jpiwowar@xxxxxxxxx>
  • To: "orasnita@xxxxxxxxx" <orasnita@xxxxxxxxx>
  • Date: Thu, 15 Jul 2010 06:19:00 -0700

Tom Kyte wrote a procedure called 'print_table' to do what you're asking. A search of asktom.oracle.com should turn it up.


Regards,

John P.

(Strange spelling? iPhone's fault. Strange content? Alas, that's all me)


On Jul 15, 2010, at 2:02 AM, "Octavian Rasnita" <orasnita@xxxxxxxxx> wrote:

Hi,

Is it possible to align vertically the columns displayed in sql*plus like under SQLite by using .mode line or in MySQL by ending the query with \G?

...something like:

<row1>
column1: 1.23
column2: "the value"
column3: 0
<row2>
column1: 2.55
column2: "another val"
column3: 1

Thank you.

--
Octavian


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5280 (20100715) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Other related posts: