Answer Posted / anil

Guys try this to get 2nd highest salary

select max(salary) from employee where salary not in (select
max(salary) from employee)

What is the difference between formal parameters and actual parameters?

1036

---

What are the advantages of oracle 12c?

1143

---

Explain oracle’s server parameter file.

965

---

What is meant by raw datatype?

1026

---

What is a schema in oracle?

988

---

What are the logical operations?

1083

---

Describe varray?

1015

---

What is blob data type in oracle?

1063

---

How to turn on or off recycle bin for the session?

1059

---

How can windows applications connect to oracle servers?

1014

---

How to create a stored program unit?

1161

---

How to create a server parameter file?

1099

---

Explain view?

995

---

What is private procedure oracle?

976

---

What happens to the current transaction if the session is killed?

948

---