define _editor=vi
-- Used by Trusted Oracle
column ROWLABEL format A15
-- Used for the SHOW ERRORS command
column LINE/COL format A8
column ERROR    format A65  WORD_WRAPPED
-- Used for the SHOW SGA command
column name_col_plus_show_sga format a24
-- Defaults for SHOW PARAMETERS
column name_col_plus_show_param format a36 heading NAME
column value_col_plus_show_param format a30 heading VALUE
-- For backward compatibility

set pagesize 9999
set linesize 131
set editfile "/tmp/afiedt.buf"
set numwidth 13
set verify off
set termout off
set autoprint on
set sqlblanklines on
alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';
alter session set nls_numeric_characters=',.';
alter session set optimizer_mode = choose;

column tree format a40

-- Defaults for SET AUTOTRACE EXPLAIN report
column id_plus_exp format 990 heading i
column parent_id_plus_exp format 990 heading p
column plan_plus_exp format a200
column object_node_plus_exp format a8
column other_tag_plus_exp format a29
column other_plus_exp format a44

set serveroutput on size 1000000 format wrapped
set trimspool on
set long 10000
set arraysize 100

column plan_plus_exp format a80

define gname=idle
column global_name new_value gname
select lower(user) || '@' || 
       substr(global_name, 1, decode( dot, 0, 
              length(global_name), dot-1) ) global_name
  from (select global_name, instr(global_name,'.') dot from global_name );
set sqlprompt '&gname> '
set termout on
set feedback on