SQL Plus Columns getting overflowed to next row

The DeptNo column when using SQLPlus in Oracle 11g XE is getting pushed down to the next row, despite having sufficient space in the window in Ubuntu 20.04 Terminal.

Answer

You can increase the size of the line using the following command:

SET LINES[IZE] 200 -- or more according to your requirement

Default line size by SQL*Plus is 80 and you can check it from your SQL*Plus as follows:

SQL> show lines
linesize 80
SQL> SET LINES 200 -- setting line size to 200
SQL> show lines -- checking now
linesize 200
SQL>