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 |
How to run sql statements through the web interface?
How to call a javascript function from pl sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What does select count (*) mean in sql?
Can you join views in sql?
What is implicit cursor in pl sql?
What is pl sql block in dbms?
what is sql.
In a table only one column how to update rows
How do you update f as m and m as f from the below table testtable?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Does sql*plus also have a pl/sql engine?
Oracle (3253)
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)