Thursday, September 15, 2005

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 it's from people who know SQL, but haven't 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.

2 comments:

Natalia said...

I am using SQL Plus with Oracle and is facing this problem. I have tried to find the possible reason why the results are not displayed properly but failed to find the exact problem. Thanks a lot for sharing the solution and sharing the reason to this problem.
sap ecc 7.0

Natalia said...

I am using SQL Plus with Oracle and is facing this problem. I have tried to find the possible reason why the results are not displayed properly but failed to find the exact problem. Thanks a lot for sharing the solution and sharing the reason to this problem.
sap ecc 7.0