Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2014
214
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. read a
  2. x=`echo $a | cut -d , -f 1`
  3. y=`echo $a | sed 's/.*,//'`
  4. c=`echo $USER | cut -c -2`"OPR"`echo $USER | cut -c 6-`
  5. sqlplus -s `echo $c`/`echo $c`@$OPERATIONAL_DB_NAME @dbl.sql $x $y
  6.  
  7. SET SERVEROUTPUT ON
  8. DECLARE
  9. x varchar2(100):='&&1';
  10. y varchar2(100):='&&2';
  11. BEGIN
  12. execute immediate 'CREATE DATABASE LINK SSS_DBL CONNECT TO ' || x || ' IDENTIFIED BY ' || x || ' USING ''' || y || '''';
  13. @1_a.sql
  14. @1_b.sql
  15. @1_c.sql
  16. END;
  17. /
  18. EXIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement