A #database link is a #schema #object in one database that enables you to access objects on another database. The other database need not be an #Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.
Once you have created a database link, you can use it to refer to #tables and #views on the other database. In #SQL statements, you can refer to a table or view on the other database by appending @dblink to the table or view name. You can query a table or view on the other database with the #SELECT statement. You can also access remote tables and views using any #INSERT, #UPDATE, #DELETE, or LOCK TABLE statement.
Website: [ Ссылка ]
Facebook: [ Ссылка ]
Instagram: [ Ссылка ]
Twitter: [ Ссылка ]
Ещё видео!