create database link dbser_link
connect to huike identified by huike
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.248)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
select t.table_name from user_tables@DBSER_LINK t where t.table_name not in (select tt.table_name from user_tables tt)
本文介绍如何通过DBSER_LINK建立与Oracle数据库的连接,并利用SQL语句查询不在特定表集中的表名。
599

被折叠的 条评论
为什么被折叠?



