Answer Posted / s. senthil kumar

There are Two Types of joins:

I. Inner Join
II. Outer Join


I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join

What is the scope of a local variable?

995

---

How to install oracle odbc drivers?

1039

---

In the oracle version 9.3.0.5.0, what does each number shows?

1224

---

How to drop a stored procedure in oracle?

996

---

How to use "for" statements in oracle?

1017

---

Write a syntax for update query in oracle?

968

---

What is a cognitive schema?

905

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2045

---

How to calculate date and time differences in oracle?

991

---

Can you have more than one content canvas view attached with a window ?

2261

---

What is recycle bin in Oracle?

1085

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1013

---

How to start a specific oracle instance?

990

---

Is oracle a language?

897

---

candidate key is subset of super key but not vice-verse explain

2016

---