Answer Posted / priyankur

@peter: your query is pretty cool but it wont work when
there are multiple salaries with same amount. I mean three
persons have same salary 24000, which is MAX sal in salary
table. In that case, below query will work.

select a.salary from employees a where 1 = (select count
(distinct b.salary) from employees b where
a.salary<b.salary)

Digit 1 is (n-1) where n is nth value. Here n is 2(Second
highest salary).

I would appreciate if anybody tried to break my above query
and explain how does this work.

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2103

---

What is bulk copy or bcp in oracle?

1184

---

How to create a stored procedure in oracle?

1151

---

What are triggers in oracle?

1097

---

What happens if you lost a data file?

1080

---

How do I spool in oracle?

1063

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

---

How to convert a date to char in oracle? Give one example.

1109

---

What is snapshot is too old? Give and example for better understand.

1651

---

What is a cursor in oracle?

1229

---

Explain mutating triggers.

1088

---

How to write text literals in oracle?

1118

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2873

---

Is truncate autocommit in oracle?

1147

---

What are the different pseudo commands? Explain in general?

1124

---