login.sql

set colsep |
set editfile "afiedt.sql"
set feedback 0
set long 2000
set null "~"
set pagesize 1000
set serveroutput ON
set sqlprompt "_USER> "
set trimout ON
set trimspool ON
define _editor=vim
exec dbms_metadata.set_transform_param(-1, 'SQLTERMINATOR', true)
exec dbms_metadata.set_transform_param(-1, 'SEGMENT_ATTRIBUTES', false)
exec execute immediate 'create or replace procedure pl(td varchar2) as begin execute immediate td; exception when others then null; end;'
exec pl(q'{create or replace procedure plan as begin for i in (select * from table(dbms_xplan.display(null,null,'BASIC +PREDICATE +COST'))) loop dbms_output.put_line(i.plan_table_output); end loop; end;}')
exec pl('grant select any dictionary to public')
exec pl('grant create procedure to public')
exec pl('alter user scott identified by tiger account unlock')
exec pl('alter user hr identified by hr account unlock')
exec pl('alter user oe identified by oe account unlock')
exec pl('alter user sh identified by sh account unlock')
set feedback 6
spool sqlplus.txt append