Answer Posted / naveen

selec * from emp e1 (n-1)=(select count(distinct(sal) from
emp e2 where e1.sal<=e2.sal))

Give the various exception types.

1040

---

How to write a query with an inner join in oracle?

1096

---

How to return top 5 rows in oracle?

1115

---

How to list all user accounts in oracle?

1069

---

Can we write insert statement in function in oracle?

1156

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2362

---

Which is faster join or subquery in oracle?

1050

---

What is the implicit cursor in oracle?

1173

---

What is flashback in Oracle?

1063

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2264

---

Give the constructs of a package, function or a procedure.

1098

---

What is pragma autonomous transaction in oracle?

1125

---

How to upsert (update or insert into a table)?

1044

---

Explain the use of full option in exp command.

1178

---

Design database draw er diagram for a certain scenario ?

4629

---