Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72608 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / bibhudatta panda
Triggers
Triggers provide a way of executing PL/SQL code on the occurrence of specific database events. For example, you can maintain an audit log by setting triggers to fire when insert or update operations are carried out on a table. The insert and update triggers add an entry to an audit table whenever the table is altered.
The actions that Informix Dynamic Server triggers perform are constrained to multiple insert, update, delete, and execute procedure clauses; whereas, Oracle allows triggers to execute arbitrary PL/SQL code. Oracle triggers are similar to stored procedures in that they can contain declarative, execution, and exception handling code blocks.
Additionally, Oracle enables triggers to be invoked by many events other than table insert, update and delete operations. However, there are restrictions.
Stored Procedures
Stored procedures provide a powerful way to code application logic that can be stored on the server. Informix Dynamic Server and Oracle both use stored procedures. Oracle also uses an additional type of subprogram called a function.
The language used to code stored procedures is a database-specific procedural extension of SQL. In Oracle it is PL/SQL and in Informix Dynamic Server it is Informix Dynamic Server Stored Procedure Language (SPL). These languages differ considerably. However, most of the individual SQL statements and the procedural constructs, such as if-then-else, are similar in both languages.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find related tables in sql server?
What is the command used to check locks in microsoft sql server?
What is rank function?
What happens if null values are involved in comparison operations?
How to change the ownership of a schema in ms sql server?
How many columns can we include on clustered index ?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to how to convert numeric expression data types using the convert() function??
What does man by sql wildcard characters in sql server?
How to install sql server 2005 express edition?
Is ssrs support other database except ms sql server?
What are the advantages of partitioning?
What is the simplest way to create a new database in ms sql server?
What is the server name in sql server?
How to call stored procedure using http soap?
