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 does varchar include?
Why we use cross join?
What does the sign mean in sql?
What is implicit cursor in pl sql?
What is the importance of sqlcode and sqlerrm?
What is linq to sql?
What are the types of operators available in sql?
Mention what does plv msg allows you to do?
What is record variable?
Does sap use sql?
Is merge a dml statement?
What are the methods of filing?
What is column?
Why is pl sql needed?
Where the sql database files are stored?