After some research, i got to know how to find the default pagesize and linesize.
SQL> show linesize
linesize 80
SQL> show pagesize
pagesize 14
swatikumari028
Last Activity: Sep 4 '13, 11:09 AM
Joined: Sep 4 '13
Location:
-
How can i check the default linesize and pagesize in Oracle?Leave a comment:
-
SQL> set linesize 40000
SP2-0267: linesize option 40000 out of range (1 through 32767)
SQL> set pagesize 100000
SP2-0267: pagesize option 100000 out of range (0 through 50000)Leave a comment:
No activity results to display
Leave a comment: