what is the difference between trigger and storedprocedures
- 16 Answers
- 27310 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 clause in sql?
How do I run a pl sql procedure in sql developer?
Which is faster subquery or join?
What is the difference between pl and sql?
What is the purpose of a sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What are basic techniques of indexing?
how to return query output in html format? : Sql dba
Can primary key be changed?
What is the use of sqlerrd 3?
define sql update statement ? : Sql dba
What do you mean by query optimization?
how to include comments in sql statements? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
What is a procedure in pl sql?
