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.

How to avoid using cursors?

1036

---

what is recursive stored procedure? : Sql dba

929

---

Can we use ddl commands in pl sql?

1068

---

What are the different dcl commands in sql?

1063

---

Can delete statement be rollbacked?

930

---

Why is sql*loader direct path so fast?

1052

---

What is group by in sql?

1022

---

Do foreign keys improve performance?

964

---

What are user defined functions?

946

---

explain mysql aggregate functions. : Sql dba

939

---

Does access use sql?

965

---

what are properties of a transaction? : Sql dba

1015

---

What are the benefits of triggers?

1119

---

Is mariadb a nosql database?

1004

---

How can I see all tables in sql?

983

---