Answer / Rakesh Kumar Singh

PL/SQL packages are collections of related PL/SQL procedures, functions, and types that can be compiled together and reused. They help to modularize code, reduce repetition, and improve performance.

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

1 Answers  

---

can i give user defined exception in a package

2 Answers  

---

What are the two parts of design view?

1 Answers  

---

Can we group by two columns in sql?

1 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

Mention what are different methods to trace the pl/sql code?

1 Answers  

---

What is execution plan in sql?

1 Answers  

---

What are the different sql languages?

1 Answers  

---

Difference between views and materialized views?

5 Answers   BirlaSoft,

---

Define a temp table?

1 Answers  

---

Are sql connections encrypted?

1 Answers  

---

What are stored procedures used for?

1 Answers  

---