Oracle dblink Operation Summary

We know that database connection operations are essential and important for us to operate databases. This article mainly introducesOracle DatabaseOfDBLINK operationThe summary of the command is here to share with you for your reference. Next we will introduce these.

-- Query the global name of the current device set

 
 

  
  
SELECT * FROM GLOBAL_NAME 
 
 

-- Establish a connection to the target database

 
 

  
  
create database link BSITZ.REGRESS.RDBMS.DEV.US.ORACLE.COM connect to tzadmin identified by sa using 'BSITZ' 
 
 

-- Query whether the connection is successful

 
 

  
  
select * from dual@BSITZ.REGRESS.RDBMS.DEV.US.ORACLE.COM 
 
 

-- Query target database information

 
 

  
  
select * from base_funcset@BSITZ.REGRESS.RDBMS.DEV.US.ORACLE.COM 
 
 

-- Write the target database

 
 

  
  
INSERT into base_funcset@BSITZ.REGRESS.RDBMS.DEV.US.ORACLE.COM values('aaa','aaa',1) 
 
 

-- Modify the target database

 
 

  
  
update base_funcset@BSITZ.REGRESS.RDBMS.DEV.US.ORACLE.COM set description='bbb' where fsid='aaa'; 
 
 

-- Delete the target database

 
 

  
  
delete from base_funcset@BSITZ.REGRESS.RDBMS.DEV.US.ORACLE.COM where fsid='aaa' 
 
 

Here is an introduction to Oracle Database DBLINK operations.