SQL*Plus output messed up

Question

when insert values into table the values are displayed unclear here is the create statement

CREATE TABLE DEPARTMENTMANAGER(
MANAGER_ID INTEGER,
LAST_NAME VARCHAR(50),
FIRST_NAME VARCHAR(50),
PHONE_NUMBER INTEGER,
SSN INTEGER,
PRIMARY KEY (MANAGER_ID)
);
INSERT INTO DEPARTMENTMANAGER
VALUES
(120.'TOM','JERRY',2233445,109-38-2483);

SELECT * FROM DEPARTMENTMANAGER;

The data which I have inserted is displaying in random way:

Take some time to present your question, so others can understand. What do you mean by random way? Were you expecting it in any other way given you have just one row? — SMA
– SMA, Commented Dec 6, 2015 at 15:50
Just click on the top-left corner of your DOS command window, Properties -> Layout, set screen buffer size width and height to something bigger like 500. Then you can see the output more clearly. — endo64
– endo64, Commented Dec 6, 2015 at 16:09

Adam Dee · Accepted Answer · 2019-03-10 04:21:42Z

1

After you create a table run the below line to fix the issue.

set linesize 200;

answered Mar 10, 2019 at 4:21

Adam Dee

112 bronze badges

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

1 Comment

Jacky Supit Over a year ago

i need to set to 500 to work on mine :) thanks

Lukasz Szozda · Accepted Answer · 2015-12-06 16:08:58Z

0

There is no problem with your data. The problem is with a way that result is presented to you.

Your client program, you use to connect to DB, does not have enough width so header and data are wrapped.

You can change the width and/or change the font size in your terminal.

answered Dec 6, 2015 at 16:08

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Collectives™ on Stack Overflow

SQL*Plus output messed up

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related