Printable View
I'm using oracle 8i and when I run a script in the worksheetplus or sqlplus My return is only 14 rows before It lists the field names again.
In oracle 8 the folder was call login.sql.
I want to change the pagesize from 14 to 50 or more.
I dont want to do just a temp fix but in the login in file I would like to change it .
Does anyone know what the name of the file is for 8i 1.6
thanks,
Mark
You can either change it for yourself only in login.sql as long as login.sql is in your $SQLPATH. Otherwise, you can change it in glogin.sql in $OH/sqlplus/admin directory.
Thank you I found that file glogin.sql
I'm new to oracle I'm in school now taking the intro to oracle sql and pl/sql for dba track.
When I opened the file I did not see where I could change the pagesize number from 14 to something higher is the default 14. Do i need to enter in a statement telling it to change the pagesize to higher.
this is for my computer at home I have a server set up with the enterprise edition on win2000 server.
This Gives you all the SQLPLUS parms and you can ask to show specific parm as shown :
SQL> show all
appinfo is ON and set to "SQL*Plus"
arraysize 15
autocommit OFF
autoprint OFF
autotrace OFF
blockterminator "." (hex 2e)
......
......
SQL> show user
USER is "SYSTEM"
[Edited by sreddy on 01-18-2001 at 06:11 PM]
Ok thank you very much I got the pagesize fixed for sql plus.
sql*plus worksheet is still set on 14 is there a different file for that one.