Duration: 23:59 min
Summary: The PL/SQL language can be used to send to commands to remote database instances using a feature called database link. This video discuss the details demanded to setup the environment to establish a remote connect to a database server, which can be another Oracle instance or any other database that has an ODBC driver. The video then shows how to configure the TNSLISTENER.ORA file to access a remote Oracle instance along with the creation of and database link. Finally, examples of queries that use the @ symbol to access remote object instances are explain followed by a brief discussion of the recommendations that the developer should be aware when using database links.