Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 32886 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
Can we call a function containing dml statements in a select query?
What is $$ in sql?
Explain select statements in sql?
Is sql the best database?
Which join is like inner join?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is auto increment?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How do I run a program in pl sql?
Is a table valued function object?
Are sql connections encrypted?
What are the different type of joins in sql?
What has stored procedures in sql and how we can use it?
Can we call stored procedure in function?
How do I remove all records from a table?
