Could anyone please be kind to assist me. I am connected to the main database I normally worked on, but now I am in need to connect to a remote database which I have credentials for, but I can’t get the right syntax.
Thanks…
I am guessing that you mean that you’d like to fetch data from the remote database. Assuming that your dba has set up a database link, then follow the tablename with @dblink:
select * from emp@dblink
The same for calling procedures and functions.
Thank you very much. I will check with my DBA to make sure such DBLink is already created.
Enjoy your day…