CODEWITHSUNDEEP
oracle-databasesqlplus
prashanth kool
prashanth kool

Reputation: 31

SQL*Plus output messed up

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:

enter image description here

Upvotes: 0

Views: 884

Answers (2)

Adam Dee
Adam Dee

Reputation: 11

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

set linesize 200;

Upvotes: 1

Lukasz Szozda
Lukasz Szozda

Reputation: 175556

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.

Upvotes: 0

Related Questions