Shulou(Shulou.com)06/01 Report--

A way for DBlink to remotely access data, which can be used to remotely retrieve tables from data, perform operations, and so on.

Language format: create public datebase link ts (dblink name) connect to scott (user name) identified by tiger (user password) using'ip (192.168.137.252) / orcle' usage: select ename,empno from emp@ts (here) where job='CLECK' deletion: drop datebase link ts (link name)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.