本文探讨了如何使用SQL语句结合DBLINK技术生成特定格式的查询语句，实现跨数据库操作。
select 'create table ' || b.OWNER || '_' || b.TABLE_NAME ||
' nologging as select * from ' || b.OWNER || '.' || b.TABLE_NAME ||
'@dblink;'
from temp_table t, dba_tables b
where t.owner = b.OWNER
and t.object_name = b.TABLE_NAME
' nologging as select * from ' || b.OWNER || '.' || b.TABLE_NAME ||
'@dblink;'
from temp_table t, dba_tables b
where t.owner = b.OWNER
and t.object_name = b.TABLE_NAME
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
