what is meant by trigger?
Answers were Sorted based on User's Feedback
Answer / mrniceksa
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. Triggers can query other tables and can include
complex SQL statements. They are primarily useful for
enforcing complex business rules or requirements. For
example, you could control whether to allow an order to be
inserted based on a customer's current account status.
Is This Answer Correct ? | 46 Yes | 7 No |
Answer / bgg
trigger is something which is executed when some specified
event occurs.
two main specifications are-
1.when the trigger should be executed(event)
2.what action must be taken when this event occurs
Is This Answer Correct ? | 15 Yes | 5 No |
Answer / sagaya maria virgin
a trigger is a statement that system execute automatically
as a side effect of a modification of database.
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / dinesh kumar
Trigger can be defined as a action that is performed on
data when event occur. Here action can modify data from
database, insert data into database etc.
Is This Answer Correct ? | 9 Yes | 5 No |
Answer / srikanth
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / a.palanisamy
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. in future use u can get old data from specified table
Is This Answer Correct ? | 0 Yes | 1 No |
3 members in a pf.how we read 3 members without using ovrdbf.using rg pgms....
what do u mean by tagging
1) How can u create the table?
8.In DSP,Define Signal and System?and various type of signals.
If i have a dataset queried from Sql and I would like to insert the dataset into a specific node in an xml document how do I do this
what is meant by trigger?
what is the diff bw sql direct and jdbc update can't we do select and updating operation in sql direct
What is the output of the following x = "abcdef" i = "a" for i in x: print(i), a) no output b) i i i i i i … c) a a a a a a … d) a b c d e f
kindly send interview materials
what is woransient key word? how it is used in java
Explain the difference between an expert and a novice user. How would your strategy for designing user interfaces for an expert user differ from that for designing user interfaces for a novice user.
what is the difference between a looping statement and a decision statement