Database Link:
A database link is a schema object in one database that enables you to access objects on another database.
After 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 and LOCK statement.
No comments:
Post a Comment