The glogin.sql File
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