How to design output in command line in Oracle?

Question

Here is the out put I get. I tried to change the set page but still this is in two line:

REG#       FNAME
---------- --------------------------------------------------
LNAME
--------------------------------------------------
SST005     John
Lucas

PKR008     John
Lucas

PKR768     John
Lucas


    REG#       FNAME
    ---------- --------------------------------------------------
    LNAME
    --------------------------------------------------
    QRT834     John
    Lucas

    PKR008     John
    Lucas

    LUCY02

how can I print each row only in one row. here is my script:

SELECT TRUCK.REG# , EMPLOYEE.FNAME, EMPLOYEE.LNAME
FROM TRUCK
LEFT OUTER JOIN TRIP
ON TRUCK.REG# = TRIP.REG# 
LEFT OUTER JOIN DRIVER
ON DRIVER.L# = TRIP.L#
LEFT OUTER JOIN EMPLOYEE
ON EMPLOYEE.E# = DRIVER.E#
;

Rob van Laarhoven · Accepted Answer · 2014-04-05 06:44:18Z

2

Use SQL*Plus commands in your script:

set pagesize 0 -- SET PAGESIZE number_of_lines
set heading off -- No headers
set linesize 200 -- Line size 
etc.

http://docs.oracle.com/cd/B10501_01/server.920/a90842/ch7.htm

answered Apr 5, 2014 at 6:44

Rob van Laarhoven

8,9552 gold badges33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to design output in command line in Oracle?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related