Answer Posted / reshma patil

when you want to retrive data from two or more tables then
you require joins.

Types of joins:-
1)Cross join/Cartain join
2)Equi join/inner join
3)Outer join
4)Self join
5)Non-equi join

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1953

---

How do I connect to oracle?

974

---

interview questions with answer for cts

2532

---

What is tns service name?

1071

---

How to rollback the current transaction in oracle?

983

---

How to experiment a data lock in oracle?

999

---

How can you use check constraints for self referential integrity?

916

---

How to check database size in Oracle?

1115

---

How do I limit the number of oracle database connections generated by weblogic server?

1006

---

What is the difference between $oracle_base and $oracle_home?

1027

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

931

---

What are the oracle differences between nvl and coalesce

1066

---

How to create a table index?

1060

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1894

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1826

---