Answer Posted / m.sivakumar

joins is a that combines the rows from two or more tables

joins are 5 types
1.cross join
2.equi join or inner join
3.outer join
4.self join
5.non_equi join

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4523

---

How to change system global area (sga) in oracle?

1013

---

What is the difference between I and G in Oracle?

1099

---

What do you understand by a database object? Can you list a few of them?

1018

---

What are a query and state the different types of queries and their uses?

1016

---

What is a cursor in oracle?

1172

---

What is the usage of control file in oracle?

1090

---

What happens if recursive calls get out of control?

1082

---

What is the sid in oracle?

967

---

How to pass a cursor variable to a procedure?

1109

---

Does oracle partitioning improve performance?

994

---

How to display row numbers with the records?

1080

---

what is the scripts in data base?

2155

---

Whats the benefit of dbms_stats over analyze?

2003

---

Why do we need integrity constraints in a database?

1022

---