Answer Posted / kedar

select max(salary) from employees where salary < (select
max(salary) from employees);


the max salary is 24000
& second max is 17000
chwck out

Explain compound trigger in oracle?

1030

---

How many types of cluster table in Oracle?

1030

---

What are the original export and import utilities?

1163

---

What is a procedure in oracle?

1181

---

What is the usage of save points in oracle database?

962

---

How to write numeric literals in oracle?

1178

---

What is the quickest way to export a table to a flat file?

964

---

What is clustered table in Oracle?

1188

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2004

---

Is primary key indexed by default in oracle?

984

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2132

---

What is Java Pool in Oracle?

1163

---

What happens if variable names collide with table/column names?

1177

---

What is meant by an index?

1135

---

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

2048

---