How do you set linesize, pagesize, and other environment parameters permanently in Oracle 10g?

how to set linesize, pagesize pe开发者_运维知识库rmanently in oracle 10g?

Is this for SQL*Plus? If so, these instructions will work:

Create a file (or edit it if it's already there) called glogin.sql in the <ORACLE_HOME>\sqlplus\admin directory
(ex. C:\Oracle\Ora10g\sqlplus\admin\glogin.sql)

This file will get executed every time you log into SQL*Plus. You can add settings here, such as "set linesize 1000". Here are the contents of my file:

glogin.sql: set linesize 1000

SELECT (YOUR NEEDS) FROM THE TABLE/VIEW . BEFORE THAT WILL BE THE:

1. set pagesize 60000
2. set linesize 144