login.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

SET FEEDBACK OFF
SET TERMOUT OFF

VARIABLE v_database  VARCHAR2(10)

BEGIN
  SELECT Lower(name)
  INTO   :v_database
  FROM   v$database;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    :v_database := '???';
END;
/

SPOOL temp.sql

SELECT 'SET SQLPROMPT "' || Lower(User) || ':' || :v_database || '> "'
FROM   v$database;

SPOOL OFF

@temp

ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'; 

SET TERMOUT ON
SET FEEDBACK ON
SET LINESIZE 100