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 |
What is nocopy in plsql?
what is the software to run the GSM gate opener program
what is the difference between an application and service??? i mean service which runs as in services.msc.
in a VB application, where the data will be stored after manipulation? what is the syntax for that?
why we use abstract in awt?
How to update a data for the views in the relational data base schema
Java is called as pure objerct oriented programming language, where as c++ is not completely object oriented.can any explain the detailed differenec between these two
What is abstract Method i want the exact definition and is there any possibility to declare class as abstract without any abstract methods in that class?If it is possible then tell me why and how?
what is mutex?
4 Answers Axiom, Blue Star, SQL Star,
how many types of operating system are avaliable?
What is the worst case of AVL tree?
we create a pf with 3 fields.2 is defined as keyfields.we lock it with alcobj command.how we find out whether the file is locked or not?is it dspfd??/