Answer Posted / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1441

---

How are functions and procedures called in PL/SQL?

1240

---

What is the most important ddl statements in sql are?

1000

---

What is sql entity?

1108

---

What is data abstraction in sql?

1035

---

What does t sql mean?

951

---

How subquery works in sql?

1075

---

Can a composite key be null?

984

---

What are different types of functions in sql?

1009

---

What is the example of procedure?

930

---

What is cursor in pl sql with examples?

1036

---

What is set serveroutput on?

1140

---

What are the ways on commenting in a pl/sql code?

1140

---

What is compilation error in pl sql?

985

---

What is sql catalog?

1028

---