Answer Posted / vishal

Here is the correct query:

select ename,sal from emp e
where 3 = (select count(distinct(sal))+1 from emp
where e.sal < sal);

Please explain oracle left join with an example?

960

---

Can multiple columns be used in group by in oracle?

930

---

Differentiate between translate and replace?

1040

---

How to estimate disk space needed for an export job?

992

---

Explain the difference between replace() and translate() functions in oracle?

976

---

What is the sid in oracle?

900

---

Explain coalesce function?

1119

---

How to export data to a csv file?

1206

---

What are the different types of trigger and explain its various uses and functions?

1010

---

How to delete a column in an existing table in oracle?

1011

---

What are nested tables?

1107

---

Explain about integrity constraint?

1078

---

Which are the five query types available in oracle?

897

---

What are the roles of dba?

1021

---

Can we convert a date to char in oracle and if so, what would be the syntax?

960

---