关于ORACLE 过程中创建DBLINK的笔记

 declare
 
         str  varchar2(4000);
        
         begin
          
            str:='create  database link chunf connect to DEVSINSYS identified by "8888" using ''(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SAAS)
    )
  )''';
 
  execute immediate str;
 
  end;