Hi,
I would like to know if I am able to implement db_link dynamically without using cursor or execute immediate? I have 2 tables stored in different location which are accessible via db_link. These 2 tables are identical in structure and the data columns that I would like to select are identical, the only difference is the db_link. For example below:

If <condition A is true> then
 select column A, B, C from tableA@dblink123;
else
 select column A, B, C from tableA@dblink456;
end if;