Answer Posted / deepa

select min(salary) from (select salary from table_name order by salary desc) where rownum<3;

What are commit, rollback, and savepoint?

935

---

What do you mean by stored procedures? How do we use it?

928

---

What plvcmt and plvrb does in pl/sql?

1248

---

What is the difference between union and union all command?

1006

---

What does trigger mean in psychology?

912

---

What is the use of %rowtype?

975

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2526

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1063

---

What is the command used to fetch first 5 characters of the string?

1331

---

What do you mean by “trigger” in sql?

1015

---

What is materialized view. What are different methods of refresh?

1327

---

How do I remove sql plus from windows 10?

1022

---

Mention what are the benefits of pl/sql packages?

998

---

How is debugging done?

918

---

Does truncate require commit?

918

---