The glogin.sql File

From NazimWIKI
Jump to navigation Jump to search

Whenever SQL *Plus starts up, it looks for a file named glogin.sql which is usually stored under $ORACLE_HOME/sqlplus/admin.

You can modify this file to store settings, like login prompts, linesize values etc etc.

For example ..


--
-- Copyright (c) 1988, 2005, Oracle.  All Rights Reserved.
--
-- NAME
--   glogin.sql
--
-- DESCRIPTION
--   SQL*Plus global login "site profile" file
--
--   Add any SQL*Plus commands here that are to be executed when a
--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
--   This script is automatically run
--


set sqlprompt "SQL &_user>"
set lines 1000
set pagesize 0