Answer / Pramod Singh Gunjiyal

Procedures are used in SQL and PL/SQL (Oracle) to encapsulate logic, reduce code redundancy, improve performance by reducing network traffic, and enhance security.

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

What is primary key and foreign key?

1 Answers  

---

How much does sql certification cost?

1 Answers  

---

What are the types of functions in sql?

1 Answers  

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

What is where clause in sql?

1 Answers  

---

How many types of relationship are there?

1 Answers  

---

What is sqlca in db2?

1 Answers  

---

Which is better stored procedure or query?

1 Answers  

---

Which nosql database is best?

1 Answers  

---

Does truncate table reset auto increment?

1 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---