SELECT
'INSERT INTO meta_data_vault.xml_vault(entry_number, record_type, xml_v)
SELECT base.entry_number AS entry_number, base.record_type AS record_type, baseXml.xml AS xml_v FROM registry.'||table_name||' as base INNER JOIN XML.entry baseXml ON base.id = baseXml.id' as ins, table_name
from
templ.dblink('host=10.128.29.139 dbname=egron_db user=egron_reader password=j98zBn21 ',
'WITH entr_tbl as (
SELECT table_name FROM information_schema.tables
WHERE table_schema = ''registry'' and table_name LIKE ''entry_61_05%'')
select table_name from entr_tbl'
) as t
(
table_name text
)