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

Question

how to set a string, forever put in oracle 10g?

Answer 1

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

Create a file (or edit it if it already exists) called glogin.sql in the <ORACLE_HOME> \ sqlplus \ admin directory
(for example, C: \ Oracle \ Ora10g \ sqlplus \ admin \ glogin. SQL)

This file will be executed every time you enter SQL * Plus. Here you can add settings such as "set linesize 1000". Here is the contents of my file:

glogin.sql: set linesize 1000

Answer 2

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

• 60000
• lineize 144