Answer Posted / rohit

The below query will provide the max and second max in
oracle in one query

select * from emp e
where 0 = (select count(sal) from emp
where e.sal < sal)
or 1 = (select count(sal) from emp
where e.sal < sal);

How to concatenate two text values in oracle?

1157

---

What is an oracle table?

1032

---

What is oracle datasource?

1040

---

Is oracle an operator?

983

---

How many types of table in Oracle?

1172

---

How to use existing values in update statements using oracle?

1111

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398

---

What is object data modeling?

1017

---

Why we use bulk collect in oracle?

1113

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

What is oracle rownum?

1016

---

What is parameterized cursor in oracle?

1221

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1984

---

What do you understand by database schema and what does it hold?

1299

---

What is the maximum number of triggers that can be applied to a single table?

1068

---