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
What is sql rowcount?
What is rtm in testing?
What steps server process has to take to execute an update statement?
what are the features and advantages of object-oriented programming? : Sql dba
What do you mean by field in sql?
How much ram can sql express use?
how can we submit a form without a submit button? : Sql dba
what is index? : Sql dba
Is left join faster than inner join?
What is the difference between joins?
Explain spool.
How to combine two stored procedures in sql?
What are the different dcl commands in sql?
Which constraints we can use while creating database in sql?
How to run sql statements with oracle sql developer?