Answer Posted / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

How to convert characters to dates in oracle?

1148

---

Write a syntax for update query in oracle?

1073

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2362

---

Is there an oracle sql query that aggregates multiple rows into one row?

1025

---

How to write date and time interval literals in oracle?

1079

---

Difference between hot backup vs. Cold backup?

1037

---

what is the difference between functional dependecy and multilevel dependency?

2517

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

---

How to define default values for formal parameters?

1093

---

Explain the use of show option in imp command.

1147

---

How do I manually uninstall oracle client?

1149

---

Whats the benefit of dbms_stats over analyze?

2064

---

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

1095

---

How do we display rows from the table without duplicates?

1015

---

What is an Oracle Instance?

1162

---