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 is the difference between a primary key and a clustered index?
what is a composite primary key ? : Sql dba
Can we group by two columns in sql?
Does access use sql?
Can we use joins in subquery?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
What is the plv (pl/vision) package offers?
what is inline command?
Explain lock escalation? : Transact sql
what is a view? : Sql dba
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,