gedit $ORACLE_HOME/sqlplus/admin/glogin.sql

--

-- Copyright (c) 1988, 2011, Oracle and/or its affiliates.

-- 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

--

DEFINE _EDITOR=vi

ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';

-- SET the SQLPROMPT to include the _USER, _CONNECT_IDENTIFIER

-- and _DATE variables.

SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER _DATE> "

-- To set the number of lines to display in a report page to 0.

SET PAGESIZE 0

-- To set the number of characters to display on each report line to 200.

SET LINESIZE 200

-- To set the number format used in a report to $99,999.

SET NUMFORMAT 999999999999