Use the Linesize command to set the number of characters a row of data can hold, with a default number of 80. If the value of the linesize is smaller,
Then a row of data in the table will need to be displayed on the screen, and if the value of Linesize is set larger, a row of data can be
Displayed in a row on the screen.
The syntax of the Linesize command is as follows:
Set Linesize n
where n means that a row of data on the screen can be
The number of characters in Na, valid range is 1-32767.
As shown below, before the Linesize setting is used
Sql> select * from EMP;
EMPNO ename JOB MGR hiredate SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7369 SMITH Clerk 7902 1 July-December-80 800
20
7499 ALLEN salesman 7698 20月-February-81 1600 300
30
7521 WARD salesman 7698 2 February-February-81 1250 500
30
EMPNO ename JOB MGR hiredate SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7566 JONES MANAGER 7839 February-April-81 2975
20
7654 MARTIN salesman 7698 2 August-September-81 1250 1400
30
7698 BLAKE MANAGER 7839 January-May-81 2850
30
EMPNO ename JOB MGR hiredate SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7782 CLARK MANAGER 7839 September-June-81 2450
10
7788 SCOTT ANALYST 7566 2 April-January-87 3000
20
7839 KING President 1 July-November-81 5000
10
EMPNO ename JOB MGR hiredate SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7844 TURNER salesman 7698 August-September-81 1500 0
30
7876 ADAMS Clerk 7788 February-April-87 1100
20
7900 JAMES Clerk 7698 March-December-81 1800
30
EMPNO ename JOB MGR hiredate SAL COMM
---------- ---------- --------- ---------- -------------- ---------- ----------
DEPTNO
----------
7902 FORD ANALYST 7566 March-December-81 3000
20
7934 MILLER Clerk 7782 2 March-January-82 1300
10
7935 Xiaoxue MANAGER 7839 January-March-98 5000 500
20
15 rows have been selected.
Sql>
As shown above, because the columns in the table are more, the data is displayed in a branch, after using the Linesize command
Sql> Set Linesize 400
Sql> select * from EMP;
EMPNO ename JOB MGR hiredate SAL COMM DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ---------- ----------
7369 SMITH Clerk 7902 1 July-December-80 800 20
7499 ALLEN salesman 7698 20月-February-81 1600 300 30
7521 WARD salesman 7698 2 February-February-81 1250 500 30
7566 JONES MANAGER 7839 February-April-81 2975 20
7654 MARTIN salesman 7698 2 August-September-81 1250 1400 30
7698 BLAKE MANAGER 7839 January-May-81 2850 30
7782 CLARK MANAGER 7839 September-June-81 2450 10
7788 SCOTT ANALYST 7566 2 April-January-87 3000 20
7839 KING President 1 July-November-81 5000 10
7844 TURNER salesman 7698 August-September-81 1500 0 30
7876 ADAMS Clerk 7788 February-April-87 1100 20
EMPNO ename JOB MGR hiredate SAL COMM DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ---------- ----------
7900 JAMES Clerk 7698 March-December-81 1800 30
7902 FORD ANALYST 7566 March-December-81 3000 20
7934 MILLER Clerk 7782 2 March-January-82 1300 10
7935 Xiaoxue MANAGER 7839 January-March-98 5000 500 20
15 rows have been selected.
The above data is clearly a lot clearer.
Oracle's linesize name order