Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 7443 Views
- Synergy, I also Faced
- E-Mail Answers
Answer Posted / ganesh
Trigger: A set of pl/sql statments that are stored
permenantly in the database it activates when ever the DML
operations performed on the table.
constraints: Set of predefind rules are applied on table
column while creating the table or after creating the
table. and automatically performed when DML statemets are
performed by user.
the main differece between the two is
trigger will not effect the existing rows(it will effects
only new rows after creating a trigger on a table),
where as in the constraints it will effect the existing
rows also.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Which database does facebook use?
if i want to display the name of students such that to which city they belong must have count greaer than two
Explain normalization in one line?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Can you tell any two advantages of stored procedures?
Display the employees whose salary is less than average salary.
Can you create a database in word?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
What is the difference between oracle and MS Access?
How to produce such kind of file?
how node connect with cpu?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What is table scan and index scan?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is the use of graph database?
