Answer Posted / deepika s verma

In Oracle we can catogrise joins in following ways -
(1) Equi Join (Query having joining condition)
- Natural Join
- Join Using
- Join ON
(2) Non Equi Join or Cartesian Join ( without using joining
condition)
(3)Outer Join
- left outer join
- right outer join
- full outer join
(4) self Join or Theta Join
(5) Cross Join
(6) Inner Join

Why cursor variables are easier to use than cursors?

1141

---

How to count duplicated values in a column in oracle?

1107

---

Explain the use of indexes option in imp command.

1264

---

How to change user password in oracle?

1099

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2523

---

What is Virtual Private Database in Oracle?

1151

---

How to run create database statement again?

1221

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

---

What is object data modeling?

1017

---

What do you mean by group by clause?

1094

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

---

What are the advantages of oracle?

1072

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2390

---

Can sub procedure/function be called recursively?

1051

---

What is the oracle implicit cursor?

1113

---