Answer / Muneesh Kumar

A stored procedure is a prepared SQL code that you can save, execute, and reuse within your Oracle Database. It encapsulates logic to perform a specific task. On the other hand, a trigger is a special type of stored procedure that automatically executes in response to certain events (such as insert, update, or delete) on a particular table. In summary, stored procedures are user-defined functions called explicitly, while triggers are automatically executed by the database.

How global cursor can be declare with dynamic trigger ?

1 Answers  

---

what is sql.

7 Answers   Ericsson, Hewitt,

---

What is linq to sql?

1 Answers  

---

How do I remove sql plus from windows 10?

1 Answers  

---

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

1 Answers  

---

How the execution will be done in exceptions?

2 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

What are properties of the transaction?

1 Answers  

---

What is scope of pl sql developer in future?

1 Answers  

---

Does varchar need length?

1 Answers  

---

What is the difference between delete and truncate commands?

1 Answers  

---

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

1 Answers  

---