Answer Posted / sachin

select distinct(sal) from employee order by sal desc limit 2,1;

What is sql and its types?

1194

---

What does closing a cursor do?

1327

---

Explain the difference in execution of triggers and stored procedures?

1024

---

what are the nonstandard string types? : Sql dba

1144

---

How do you declare a variable in pl sql?

1032

---

what are different types of collation sensitivity? : Sql dba

1075

---

Is not equal in sql?

1018

---

Is sqlite thread safe?

1058

---

What is relationship? How many types of relationship are there?

1188

---

Can we write ddl statements in functions?

1121

---

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

1441

---

What are the most important characteristics of pl/sql?

1165

---

What is trigger and how to use it in sql?

1025

---

What is parallel hint?

1332

---

What is trigger explain it?

1020

---