首页 > 数据库技术 > 详细

call_compile.sql

时间:2016-09-20 13:47:47      阅读:334      评论:0      收藏:0      [点我收藏+]

set echo off prompt prompt ================================================================================ prompt call_compile.sql &1 &2 &3 &4 &5 prompt

set echo off pagesize 0 feedback off verify off serveroutput on size 1000000

define v_input_un          = &1

define v_input_pw          = &2

define v_input_conn_str    = &3

define v_reconnect_un      = &4

define v_reconnect_pw      = &5

define v_compile_work_file = ./log/compile_work_file_&v_input_un..sql

--
-- reconnect to make sure the following pl/sql block can be run successfully
--
connect &v_reconnect_un/&v_reconnect_pw@&v_input_conn_str
set echo off pagesize 0 feedback off verify off serveroutput on size 1000000

-- -- construct the work file --

spool &v_compile_work_file

begin
  if (‘&v_input_un‘ = ‘&v_na‘) then
    dbms_output.put_line(‘-- Skipping this user ...‘);
  else
    dbms_output.put_line(‘@gen_compile &v_input_un &v_input_pw &v_input_conn_str‘);
  end if;
end;
/
spool off
--
-- call the work file
--
@&v_compile_work_file

 

call_compile.sql

原文:http://www.cnblogs.com/feiyun8616/p/5888232.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!