Answer Posted / sunny kumar rana

1) A stored procedure can accept parameters while a trigger
cannot.
2) A trigger can’t return any value while stored procedures
depand on condition.
3) A trigger is executed automatically on some event while
a stored procedure needs to be explicitly called.
4) Triggers are used for insertions, update and deletions
on tables while stored procedures are often using
independently in the database.
5) A trigger cannot be written in a stored procedure.
However, the reverse is not possible.

What does sql stand for?

986

---

what are the different functions in sorting an array? : Sql dba

1014

---

Is pl sql still used?

973

---

Does sqlite need a server?

1042

---

What is sql dialect?

1112

---

What are database links used for?

1041

---

what is denormalization. : Sql dba

1104

---

How to change the order of columns in Oracle SQL Plus ?

1054

---

What is plpgsql language?

1058

---

What are the usages of sql?

1056

---

What is the difference between the implicit and explicit cursors?

1046

---

What does (*) mean in sql?

945

---

Enlist the data types that can be used in pl/sql?

1063

---

Can we use delete in merge statement?

1037

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1002

---