Re: [Q] Formatting query results

From: Madhavi Lokam <gmadhavi_at_pms991.pms.ford.com>
Date: 1995/05/02
Message-ID: <3o5tcf$m1j_at_eccdb1.pms.ford.com>#1/1


In article <3nrfum$35g_at_ixnews2.ix.netcom.com>, chuckh_at_ix.netcom.com (Chuck Hamilton) writes:
|> Is there a way to override the default column width in a result set?
|> For example I want to display "last name, first name" with...
|>
|> select fname||', '||lname "Full Name" from people;
|>
|> But that gives me a column that's 42 characters wide. I'd rather set it
|> to something around 30 characters so I can fit more columns accrossed
|> the page. How do I do it?
|> --
|> ><> Chuck Hamilton <><
|> ><> chuckh_at_ix.netcom.com <><

Use SQLPLUS format statement.

at SQLPLUS PROMPT,

COLUMN "Full Name" FORMAT A30
select fname||', '||lname "Full Name" from people;

This sets Full Name to 30 characters.
COLUMN Received on Tue May 02 1995 - 00:00:00 CEST

Original text of this message