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 left and left outer join?
How do I save a stored procedure?
Does varchar need length?
What is a full join?
I have a CURSOR then why we need BULK COLLECT again?
What are the three forms of normalization?
What is sql query limit?
What does “select count(1) from tab” result?
What is a trigger ?
11 Answers Accenture, BirlaSoft,
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What does rownum mean in sql?
What is package in pl sql?