Answer Posted / shivaprasad

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

How does the on-delete-cascade statement work?

1061

---

How to define an explicit cursor in oracle?

989

---

Why do we use coalesce function in oracle?

1053

---

How to retrieve data from an explicit cursor?

1009

---

What is a subquery in oracle?

1043

---

How to define a data field as not null?

1061

---

What are the various oracle database objects?

1093

---

Is oracle an open source?

1021

---

Explain the use of ignore option in imp command.

977

---

Give the various exception types.

949

---

What is an oracle?

958

---

What are temporal data types in oracle?

1066

---

What is integrity and what is constraint??Explain with example

2215

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2248

---

What are oracle functions?

976

---