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.

Why truncate is faster than delete?

1062

---

what are the differences among rownum, rank and dense_rank? : Sql dba

998

---

What is native sql query?

976

---

Name the different types of indexes in sql and define them.

1086

---

What is a unique key?

1013

---

how to enter numeric values as hex numbers? : Sql dba

1015

---

How do I save the results of sql query in a file?

937

---

How can get second highest salary in sql?

917

---

Explain the the delete statements in sql?

990

---

Is record in oracle pl sql?

912

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

952

---

What is difference between db2 and sql?

947

---

What are different types of keys?

1030

---

Why are aggregate functions called so?

906

---

What is trigger and how to use it in sql?

970

---