Newbie with basic question about formatting

[gozu]

Here is my query:

SELECT departments.department_name AS "Department name", locations.STREET_ADDRESS AS "Mailing address", locations.city, locations.state_province, locations.postal_code
FROM departments, locations
WHERE departments.location_id = locations.location_id
AND locations.country_id = 'US'
ORDER BY department_name;

and here is what the output is like:

Department name                Mailing address
------------------------------ ----------------------------------------
CITY                           STATE_PROVINCE            POSTAL_CODE
------------------------------ ------------------------- ------------
Administration                 2004 Charade Rd
Seattle                        Washington                98199
IT                            2014 Jabberwocky Rd
Southlake                      Texas                     26192
 
 

my query needs to list department names and mailing addresses of the departments located in the U.S. My current query accomplishes the result fine but the formatting is wrong because I need it to look like this (it's an sql excercise, I'm a newbie):

Department Name                Mailing Address
----------------------                -----------------------------------------------------
Administration                     2004 Charade Rd, Seattle, Washington 98199
IT                                2014 Jabberwocky Rd, Southlake, Texas 26192
 

How can I do this?

Thanks for your time.

PS: it doesn't matter if the displayed data is folded because of the number of lines allowed.

[Mala232]

Hi,

Use set linesize 100 or more number to fit in the screen

SQL> SET LINESIZE 100;
SQL> type your query here

[debasisdas]

SQL*PLUS has some default setting , as per that it can display 80 chars per line and 14 lines per page . After the specified value the display will move to next line / page. to change the default values

ex
--------

set line 120

(maximun 32767)

set pages 50
(maximum 50000)

u can also do the same from the menu by changing the environment variables.