I am trying to execute the query for different db links. I am using a for loop concatenated dblink. But it is throwing a db link expected error.
begin
for i in (select db_link from db_table )
loop
select * FROM table@||i.db_link;
end loop;
end;
I am trying to execute the query for different db links. I am using a for loop concatenated dblink. But it is throwing a db link expected error.
begin
for i in (select db_link from db_table )
loop
select * FROM table@||i.db_link;
end loop;
end;