What is a database link?
Answers were Sorted based on User's Feedback
Answer / anil_abbireddy
database link establishes a link between two databases
there are 3 type os database links
1. private
2. public
3. network
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / prabha
consider database DB1 and table TB1
we can able to access TB1 from another Database
Ex . select * from TB1@LINK1
| Is This Answer Correct ? | 0 Yes | 0 No |
It's a named path through which remote database can be
accessed.
| Is This Answer Correct ? | 0 Yes | 1 No |
what are the differences among rownum, rank and dense_rank? : Sql dba
Is subquery faster than join?
How many row comparison operators are used while working with a subquery?
How to read xml file in oracle pl sql?
How does one load ebcdic data? : aql loader
What are different functions in sql?
What will happen after commit statement ?
Can dml statements be used in pl/sql?
Explian rowid, rownum?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
Explain the update statement in sql
Why join is faster than subquery?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)