what is the difference between trigger and storedprocedures
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
How do I audit the sql sent to the server?
how do you know if your mysql server is alive? : Sql dba
what are the different type of normalization? : Sql dba
how to create a new table in mysql? : Sql dba
What is lexical units in pl sql?
Does view store data in sql?
what is the different between now() and current_date()? : Sql dba
Explain the difference between 'between' & 'and' operators in sql
how to create a table index in mysql? : Sql dba
What is cartesian join in sql?
How can check sql version from command line?
Can we perform dml in function?
How many unique keys can a table have?
How to assign sql query results to pl sql variables?
How do you sort in sql?