Formatting query for report [message #19174] |
Mon, 04 March 2002 06:46 |
James
Messages: 120 Registered: June 2000
|
Senior Member |
|
|
How do I run a query to get the row column names to not return with each record so I can get this format?
Name Address City State Zip Code
---------- ---------- --------- ----- --------
John Doe 1 Main St. St. Louis MO 63133
Mary Jones 2 Old Ave. Plainville Il 63103
|
|
|
|
Re: Formatting query for report [message #19182 is a reply to message #19174] |
Mon, 04 March 2002 10:39 |
James
Messages: 120 Registered: June 2000
|
Senior Member |
|
|
I just set it to 500 and that eliminated the problem, but I still need to get each rows data on one line, instead of on three lines for each row. I am trying to find some documentation for setting column widths, which I am hoping will solve that problem.
I am new to Oracle and don't have any books on it yet.
|
|
|
|
Re: Formatting query for report [message #19240 is a reply to message #19182] |
Wed, 06 March 2002 10:22 |
sfhollands
Messages: 15 Registered: October 2001
|
Junior Member |
|
|
For setting the column widths
column colname format Alength
eg.
column emp_name format a40
the above sql*plus stt limits the width of column emp_name to 40
to limit the width of a record
set linesize value
|
|
|