Re: [Q] Formatting query results
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