Setting up a parameter Value of oracle user session profile "glogin.sql/login.sql"
## For change the setting of session globally we need to change in below .sql file
$oracle_home/sqlplus/admin/glogin.sql
set pages 200
set lines 200
set serveroutput on
etc.
## If you want to change a setting for personal user session,Follow below Steps:
Create a login.sql file somewhare in your directory path.
Define a variable with SQLPATH="Directory location of your login.sql file" in your .profile/.bashrc etc.
Set some parameters value in login.sql file with help any text editor like "vi".
set pages 200
set lines 200
set serveroutput on
etc.
$oracle_home/sqlplus/admin/glogin.sql
set pages 200
set lines 200
set serveroutput on
etc.
## If you want to change a setting for personal user session,Follow below Steps:
Create a login.sql file somewhare in your directory path.
Define a variable with SQLPATH="Directory location of your login.sql file" in your .profile/.bashrc etc.
Set some parameters value in login.sql file with help any text editor like "vi".
set pages 200
set lines 200
set serveroutput on
etc.

Comments
Post a Comment