Answer Posted / ashi

Sub query: The sub query has more than one select
statement,the inner query which executes first and then it
will be the value of the 2nd query.
EX:
select ename from emp where sal>(select avg(sal) from emp);

Joins:
When the data from more than one table in the database,then
a join condition used.Rows in the one table can be joined to
rows in the other table according ro the common values
existing in corresponding columns
EX:
select dname,ename from emp,dept where emp.deptid=dept.deptid;

How to return top 5 rows in oracle?

1062

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

---

How to insert multiple rows with one insert statement in oracle?

1087

---

what is a Nested Loop join?

2117

---

What is proxy method?

974

---

Give the various exception types.

993

---

How to best split csv strings in oracle 9i?

1041

---

Why does oracle 9i treat an empty string as null?

1056

---

How to declare a local variable?

1119

---

Give the different types of rollback segments.

1031

---

How to start a new transaction in oracle?

1088

---

Which is better Oracle or MS SQL? Why?

4944

---

How to assign a tablespace to a users in oracle?

1048

---

Explain an exception and its types?

1073

---

What is difference between cartesian join and cross join?

1088

---