Toad World® Forums

What is the syntax to connect to a remote database within sql navigator?


#1

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…


#2

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.


#3

Thank you very much. I will check with my DBA to make sure such DBLink is already created.

Enjoy your day…