Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- read a
- x=`echo $a | cut -d , -f 1`
- y=`echo $a | sed 's/.*,//'`
- c=`echo $USER | cut -c -2`"OPR"`echo $USER | cut -c 6-`
- sqlplus -s `echo $c`/`echo $c`@$OPERATIONAL_DB_NAME @dbl.sql $x $y
- SET SERVEROUTPUT ON
- DECLARE
- x varchar2(100):='&&1';
- y varchar2(100):='&&2';
- BEGIN
- execute immediate 'CREATE DATABASE LINK SSS_DBL CONNECT TO ' || x || ' IDENTIFIED BY ' || x || ' USING ''' || y || '''';
- @1_a.sql
- @1_b.sql
- @1_c.sql
- END;
- /
- EXIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement