select 'select ''' || table_name || ''' ' || '||' || ' count(*) from ' ||
owner || '.' || table_name || '@dblink' || chr(10) || 'union all' ||
chr(10) || 'select ''' || table_name || '''' || '||' ||
' count(*) from ' || owner || '.' || table_name || ';'
from sync_table@dblink
where table_name like 'TAB\_SYNC\__\__' escape '\';
owner || '.' || table_name || '@dblink' || chr(10) || 'union all' ||
chr(10) || 'select ''' || table_name || '''' || '||' ||
' count(*) from ' || owner || '.' || table_name || ';'
from sync_table@dblink
where table_name like 'TAB\_SYNC\__\__' escape '\';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25148509/viewspace-715096/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
存储过程单引号问题
请登录后发表评论
登录
全部评论
