Answer Posted / samir kumar sahoo

Generally there are five types of joins in oracle:

Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin

Is primary key indexed by default in oracle?

928

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2252

---

How to use group functions in the select clause using oracle?

1022

---

How many types of table in Oracle?

1058

---

What is a cursor and what are the steps need to be taken?

1116

---

Explain alias?

1078

---

What is recycle bin in Oracle?

1085

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1668

---

How to view the tablespaces in the current database?

927

---

Explain the use of rows option in imp command.

1040

---

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

1223

---

Explain user account with reference to oracle.

926

---

Is it possible to insert comments into sql statements return in the data model editor ?

2510

---

What is a partition in oracle?

1035

---

How to recover a dropped table in oracle?

983

---