Home » SQL & PL/SQL » SQL & PL/SQL » SQL Plus Configuration File
SQL Plus Configuration File [message #20666] Wed, 12 June 2002 09:03 Go to next message
Suresh Krishna
Messages: 5
Registered: June 2002
Junior Member
Please give me the configuration file name and the syntax to enter parameters for SQL Plus so that we can enter the settings like NLS_DATe_Format, Serveroutput on etc.
Re: SQL Plus Configuration File [message #20667 is a reply to message #20666] Wed, 12 June 2002 09:24 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
look for the the file glogin.sql
it should it $ORACLE_HOME/sqlplus/admin.
edit the file add your entries
--  Add any sqlplus commands here that are to be executed when a user
--  starts SQL*Plus on your system
column ROWLABEL format A15
-- Used for the SHOW ERRORS command
column LINE/COL format A8
column ERROR    format A65  WORD_WRAPPED
-- Used for the SHOW SGA command
column name_col_plus_show_sga format a24
-- Defaults for SHOW PARAMETERS
column name_col_plus_show_param format a36 heading NAME
column value_col_plus_show_param format a30 heading VALUE
-- Defaults for SET AUTOTRACE EXPLAIN report
column id_plus_exp format 990 heading i
column parent_id_plus_exp format 990 heading p
column plan_plus_exp format a60
column object_node_plus_exp format a8
column other_tag_plus_exp format a29
column other_plus_exp format a44
-- give any environment settings here.
set termout off
set pagesize 25
set linesize 100
set serveroutput on
alter session set nls_date_format='dd/mm/yyyy';
set termout on;
Previous Topic: DATE Format
Next Topic: Difference between application procedures and stored procedures
Goto Forum:
  


Current Time: Fri Mar 29 10:57:42 CDT 2024