Answer / guest

An integrity constraint defines a business rule for a table
column which automatically takes care by Oracle internally.
Intefrity Constraints are NOT NULL,UNIQUE,CHECK ,PRIMARY
KEY,FOREIGN KEY.


A database trigger is a procedure written in PL/SQL and
Will run implicitly when data is modified or when some user
or system actions occur.Triggers are database objects which
gets stored in database and get fires when INSERT or UPDATE
statement attempts to violate the integrity rule, Oracle
must roll back the statement and return an error if trigger
exists.Database triggers are BEFOR/AFTER/{BEFORE|AFTER}
{row|statement etc.

Answer / rao

main diff is when we use the trigger voilation rules of
trigger body will not affect existing data.but in case of
constrinat will affect the exsting data also.

Answer / kalyana chakravarthy

Intigrity constraints are Proactive-- Like they take the
cols into consideration before sitting on it like if U levy
a PK on a col having duplicate or null values it will not
obey to sit on that col

Triggers are reactive-- Triggres react only when a DML
occurs. When it comes and sit on a table then its starts
working and never considers what happened before it arrival

Both are used to perform business rules

Answer / santu sarkar

1> A database trigger is written in PL/SQL. Integrity Constraints are CHECK Constraints, Not NULL, Unique key, primary key and foreign key.
2> Trigger will not affect the existing data. Constraint will affect the existing data.

What is pl sql architecture?

0 Answers  

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

What is the left table in sql?

0 Answers  

---

How do I save a stored procedure?

0 Answers  

---

What is execution plan in sql?

0 Answers  

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

Are null values same as that of zero or a blank space?

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---