SQL Plus Configuration File [message #20666] |
Wed, 12 June 2002 09:03 |
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 |
|
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;
|
|
|