3 Replies Latest reply: Aug 6, 2012 4:30 PM by damorgan RSS


      I created the login.sql and put it under C:\app\...\product\11.2.0\client_1\sqlplus\admin
      but after I run SQLPLUS and test by putting show serveroutput, it looks like it didn't run login.sql.
      Is there anything else I need to do to make it work?

      Here is the content of login.sql

      set termout off
      set serveroutput on size 1000000 format wrapped
      column object_name format a30
      column segment_name format a30
      column file_name format a40
      column name format a30
      column file_name format a30
      column what format a30 word_wrapped
      column plan_plus_exp format a100
      set trimspool on
      set long 5000
      set linesize 131
      set pagesize 9999
      define gname=idle
      column global_name new_value gname
      select lower(user) || '@' ||
      substr( global_name, 1, decode( dot,
      0, length(global_name)
      from (select global_name, instr(global_name, '.') dot
      from global_name );
      set sqlprompt '&gname> '
      set termout on

      Edited by: Rinne on Aug 6, 2012 3:34 PM