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

What do you understand by a database object?

1055

---

How do I escape a reserved word in oracle?

1195

---

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.

2109

---

Are truncate and delete commands same? If so why?

1145

---

How to assign data of the deleted row to variables?

1070

---

How can we create the complete backup of data in the oracle.

2155

---

Can we create database in oracle using command line ?

1082

---

what are steps for interface? where is exchange rate defined in which table?

2151

---

How to define a procedure inside another procedure?

1016

---

How to create a stored procedure in oracle?

1102

---

How can I see all tables in oracle?

1006

---

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

2553

---

Is it possible to split the print reviewer into more than one region ?

2280

---

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??

1724

---

What are the restrictions in a oracle read only transaction?

1028

---