What all new Oracle users should know about SQL Plus

Ok, I realize anyone who’s used oracle much will already know this, but I still get asked this question a lot. Usually its from people who know SQL, but havent worked a lot with Oracle.

If you are using SQL Plus with Oracle, you may be surprised by the odd way it displays results. This is because by default SQL Plus assumes your screen is only 80 characters wide, and 14 rows tall, and wraps accordingly.

You can fix this by entering the following in SQL Plus:

set pagesize 50000 
set linesize 32767

By default those values are 14 and 80 respectively. 32767 is the maximum size for linesize and 50000 is the maximum size for pagesize.

Related Posts by Categories