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:
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
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
Post a Comment