CODEWITHSUNDEEP
sqloracle-databaserelational-databasedatabase-schema
David Garcia
David Garcia

Reputation: 2696

Set line width for oracle cmd line

I am using SET LINESIZE 32767 for displaying properly data in tables, however there is a table that does not accommodate all the columns, also what is the difference between linesize and SET NUM

TABLE

CREATE TABLE STAFF(
EMP_ID NUMBER NOT NULL,
EMP_NAME VARCHAR2(20),
EMP_DOB DATE,
EMP_TEL VARCHAR2(20),
EMP_EMAIL VARCHAR2(50),
EMP_ADDR VARCHAR2(100),
EMP_HIREDATE DATE,
EMP_ENDDATE DATE,
EMP_SALARY NUMBER(7,2),
EMP_SUPERVISOR NUMBER,
 JOB_CODE NUMBER,
 BRA_CODE NUMBER);

INSERT SAMPLE

INSERT INTO STAFF VALUES (NULL,'Andres Baravalle',to_date('25/03/1975','dd/mm/YYYY'),'723 3403-2817','[email protected]','P.O. Box 879, 1742 Porttitor',to_date('15/04/2007','dd/mm/YYYY'),to_date('19/02/2007','dd/mm/YYYY'),49670,NULL,1,10);

SELECT * FROM STAFF; yields the following

output

Edit----

Guys how can i get rid of all the space in the timestamp attributes

Get rid of space

Upvotes: 3

Views: 67816

Answers (3)

Andrew Russell
Andrew Russell

Reputation: 485

Additionally answer you last edit, you can reformat the various columns using "column".

COLUMN emp_id format a20
COLUMN emp_tel format a15
COLUMN dept_time format a21
COLUMN arrv_time format a21

Which will format the fields above and wrap excess onto the next line.

Upvotes: 1

gfortune
gfortune

Reputation: 2629

It looks like your console is wrapping for you. Have you tried outputting that data to a text file and opening it in a proper text editor? Looking it through a console is always going to be constrained by the limits of the console. Spool it out to a file and see what you get.

Upvotes: 2

Mouna Cheikhna
Mouna Cheikhna

Reputation: 39658

SET LINESIZE sets the total number of characters that SQL*Plus displays on one line before beginning a new line.

However SET NUM is totaly different and sets the default width for displaying numbers.

see here

try setting also your pagesize to be able to see all your table content n one page :

set pagesize n

and increasing your linesize

Upvotes: 9

Related Questions