How to format the columns in sqlplus while displaying it in the terminal?

Question

I was using the HR account in the Oracle DB XE on Ubuntu. So I am running the SQL*Plus in the terminal. I know that the maximum displayable linesize is 150 without wrapping but when I display the employee table in the terminal the last two columns end up wrapping around. I have

set lines 150;
set trimout on;
set pagesize 10000;
set tab off;
set wrap on;

and I am seeing

as you can see here the columns LAST_NAME, EMAIL, HIRE_DATE are taking extra blank spaces which could be other wise utilized for displaying the columns which get wrapped. I tried flicking the wrap on and off and that doesn’t help either. How can I optimize the space consumed as I am also spooling the file and the output is very confusing to look at.

ScaisEdge · Accepted Answer · 2016-01-02 17:24:50Z

2

try adding

COLUMN LAST_NAME FORMAT A10

/

for limit to 10 alfanum char

answered Jan 2, 2016 at 17:24

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

6 Comments

chris_jay Over a year ago

thank you for your response, it worked. but i was wondering whether this limit affected while displaying only or even while inserting new elements?

chris_jay Over a year ago

hey i messed up. i did the above query with a number column and now its just returning # signs in that particular column. the employee_id column only had 3 digit numbers to begin with so i went in with A5 but now this. help

ScaisEdge Over a year ago

You mean column with integer or number value content?

chris_jay Over a year ago

yes, if you look in the picture the first column aka EMPLOYEE_ID has 3 digit numbers. so i formatted with A5. now i am getting #######

ScaisEdge Over a year ago

try with COLUMN EMPLOYEE_DI FORMAT 999

|

Collectives™ on Stack Overflow

How to format the columns in sqlplus while displaying it in the terminal?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related