CODEWITHSUNDEEP
oracle10gsqlplus
Bhavana
Bhavana

Reputation: 349

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

how to set linesize, pagesize permanently in oracle 10g?

Upvotes: 6

Views: 56541

Answers (2)

aly ibn ali
aly ibn ali

Reputation: 11

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

  1. set pagesize 60000
  2. set linesize 144

Upvotes: -2

Ben Jakuben
Ben Jakuben

Reputation: 3237

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

Upvotes: 16

Related Questions