Home » SQL & PL/SQL » SQL & PL/SQL » Formatting query for report
Formatting query for report [message #19174] Mon, 04 March 2002 06:46 Go to next message
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 #19176 is a reply to message #19174] Mon, 04 March 2002 07:05 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
r u getting column name with each record ? what is u r pagesize try setting pagesize .
Re: Formatting query for report [message #19182 is a reply to message #19174] Mon, 04 March 2002 10:39 Go to previous messageGo to next message
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 #19198 is a reply to message #19182] Mon, 04 March 2002 23:44 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try setting linesize
e.g. set linesize 400
Re: Formatting query for report [message #19240 is a reply to message #19182] Wed, 06 March 2002 10:22 Go to previous message
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
Previous Topic: Not like Operator
Next Topic: Finding the Minimum value
Goto Forum:
  


Current Time: Thu Mar 28 19:09:56 CDT 2024