file name where pagesize can be changed

[clearview]

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

[marist89]

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.

[clearview]

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.

[sreddy]

This Gives you all the SQLPLUS parms and you can ask to show specific parm as shown :
<font face=courier>
SQL> show all
appinfo is ON and set to "SQL*Plus"
arraysize 15
autocommit OFF
autoprint OFF
autotrace OFF
blockterminator "." (hex 2e)
......
......
</font>

<font face=courier>
SQL> show user
USER is "SYSTEM"
</font>

[Edited by sreddy on 01-18-2001 at 06:11 PM]

[clearview]

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.