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.

What are the difference between “where” and “having” clause in sql server?

1063

---

Scalability, Availability, Integration with internet, etc.)?

2874

---

What is tabulation?

945

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

957

---

What is the difference between a fill factor of 100 and 0?

976

---

How do I setup a local sql server database?

997

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

1038

---

Explain how you can deploy an SSRS report?

148

---

What is the difference between a check constraint and a rule?

1235

---

What is the difference between writing data to mirrored drives versus raid5 drives

923

---

What are the different types of join?

1165

---

How do I edit a procedure in sql server?

952

---

What is 2nf in normalization?

982

---

Explain raiserror in sql server?

1016

---

What is rs.exe utility?

156

---