Answer / Amit Trivedi

PL/SQL is used in Oracle Database to write procedural code, which allows for more complex database operations than what can be achieved with SQL alone. It provides features like loops, conditional statements, cursors, and user-defined functions, making it possible to create more efficient and reusable code.

Is it possible to update views?

1 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---

Which command is used to delete a package?

1 Answers  

---

what is the difference between join and union? : Sql dba

1 Answers  

---

Can a key be both primary and foreign?

1 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

Why is partition used in sql?

1 Answers  

---

What is rename in sql?

1 Answers  

---

What are the advantages of indexing?

1 Answers  

---