what is the difference between trigger and storedprocedures
- 16 Answers
- 29392 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / sohail
Trigger and procedures are same but the substantial
difference is when they run.procedure is invoked explicitly
by the user and trigger is executed implicitly. another
diffrence is procedure cannot have the same name as table
name,funtion name or package name but trigger can have same
name as table name or procedure name.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is the use of <> sql?
What is lexical units in pl sql?
What is the purpose of cursors in pl/sql?
What is data types in sql?
what is auto increment? : Sql dba
What is a sql profiler?
Can we create a trigger on view?
Define concurrency control. : Transact sql
What is serial sql?
Can delete statement be rollbacked?
what is data integrity? : Sql dba
Explain normalization and what are the advantages of it?
Is null operator in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What types of commands can be executed in sql*plus?
