Explain database link?
Answer / Ajay Kumar Choudhary
A database link in Oracle provides a means to establish connectivity between two or more databases. It allows users to query data residing in remote databases as if it were local. Database links are created using the CREATE DATABASE LINK statement and can be used in SQL statements to access remote data using the @ symbol followed by the database link name.
| Is This Answer Correct ? | 0 Yes | 0 No |
definition of cluster and non-clustered index?
What is oracle host variable?
How to omit columns with default values in insert statement in oracle?
Differnce between view and index
What is bulk copy or bcp in oracle?
How to define a specific record type?
What are the commands youd issue to show the explain plan for select
How to synchronize 2 schema's objects?
What is Data Block ?
Can a Tablespace hold objects from different Schemes ?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
What are the Characteristics of Data Files ?