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 should turn it up.


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:


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:

column1: 1.23
column2: "the value"
column3: 0
column1: 2.55
column2: "another val"
column3: 1

Thank you.


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

The message was checked by ESET NOD32 Antivirus.

Other related posts: