Answer / Harish Chandra Kanojia

PL/SQL is needed for various reasons, including: 1) Procedural control, allowing complex business logic to be encapsulated within stored procedures and functions. 2) Improved performance by minimizing network traffic through caching and avoiding repeated SQL statements. 3) Enhanced data integrity and security through triggers and sequences. 4) Support for complex data types, collections, and exceptions.

how to create a new view in mysql? : Sql dba

1 Answers  

---

Explain the working of primary key?

1 Answers  

---

What is oracle sql developer?

1 Answers  

---

how many triggers are allowed in mysql table? : Sql dba

1 Answers  

---

What is sqlca in db2?

1 Answers  

---

Is sql microsoft?

1 Answers  

---

how will i became good database developer?

1 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

1 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

what is a tablespace? : Sql dba

1 Answers  

---

What is the plv (pl/vision) package offers?

1 Answers  

---

Is sql procedural language?

1 Answers  

---