Re: Vertical align columns in sql*plus

Octavian,

I knew I saw something like this before, so I asked one of
my coworkers who writes a lot of reporting queries.

You can try using newline...

For example, run this query:

set lines 80
set pages 2000
set echo off
set verify off
set feedback off
set head off

column who    newline
column dbase  newline
column dspace newline
column tspace newline
column prof   newline

select 'USERNAME:             '||username who,
       'DATABASE:             '||name dbase,
       'DEFAULT TABLESPACE:   '||default_tablespace dspace,
       'TEMPORARY TABLESPACE: '||temporary_tablespace tspace,
       'PROFILE:              '||profile prof
from v$database, dba_users
;

- Maureen

Octavian Rasnita 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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: