Results 1 - 15 of about 2311 sawaal for "trigger"
A trigger is a fragment of code that you tell Oracle to run before or after a table is modified. A trigger has the power to make sure that a column is filled in with default information make sure...well, A trigger is a fragment of code that you tell Oracle to run before or after a table is modified. A trigger has the power to1 make sure that a column is filled in with default information2 make sure
Posted in
Computers & Technology by blogger01 at 12:24 PM on May 23, 2008
Dear;A trigger is a fragment of code that you tell Oracle to run before or after a table is modified. A trigger has the power to make sure that a column is filled in with default information make t checkapprovedp in t,f ;...well SharadA trigger is like an IDMS user exit, an opening in the code where you can branch out and "do your own thing", prior to performing the insert, update or delete
Posted in
Computers & Technology by Sharad Singh at 8:42 PM on May 15, 2008
trigger :It is a event ,means when you insert a row from one table and create a trigger on child table as it should auto matically insert into that.procedure :s a collection of sql paced together and unless otherwise cannot be avoided it is recommended not to use cursors.Trigger is fired when an event is invoked like an Insert, Update or a delete statement on a table. It can be fired based on your
Posted in
Computers & Technology by tanu priya at 3:11 PM on July 15, 2008
A database trigger is a stored procedure that is invoked automatically when a predefined event occurs.Database triggers enable DBAs Data Base Administrators to create additional relationships between separate databases.For example, the modification of a record in one database could trigger the modification of a record in a second database...A database trigger is a PL/SQL block that can defined
Posted in
Computers & Technology by Vinay at 4:17 AM on October 27, 2008
Oracle allows you to define procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the associated table. These procedures are called database triggers.Triggers are similar to stored procedures. A trigger can include SQL and PL/SQL statements to execute as a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked
Posted in
Computers & Technology by joydeep bhat at 10:00 PM on December 18, 2008
A DDL trigger is defined to handle a DDL statement event, like create, alter and drop tables, views, indexes, etc. DDL triggers can be used to generate warning messages on database object changes. The format of creating a DDL trigger should be: CREATE TRIGGER triggername ON DATABASEAFTER ddleventtypesAS statementsGO-- ddleventtypes are keywords like:-- CREATETABLE, ALTERTABLE, DROPTABLE, ...Below is a
Posted in
Computers & Technology by shivangi kap at 3:45 PM on November 27, 2008
A DML trigger is a trigger declared to handle a DML event, which occurs when an INSERT, UPDATE or DELETE statement is executed. If you want to create a DML trigger, you should use the "CREATE TRIGGER" statement in the following format: CREATE TRIGGER triggername ON tablenameAFTER INSERT, UPDATE, DELETE AS statementsGOThe tutorial exercise below shows you a very simple DML trigger defined
Posted in
Computers & Technology by shivangi kap at 3:41 PM on November 27, 2008
If you want to list all triggers defined in the current database, you can use the catalog view, sys.triggers, as shown in the following tutorial example: USE FyiCenterData;GOCREATE TRIGGER newuser ON fyiusersAFTER INSERT AS PRINT New users added.;GOSELECT FROM sys.triggersGOname objectid parentid type typedesc ------------ ----------- ----------- ---- ------------dmlmessage 690101499 674101442 TR
Posted in
Computers & Technology by shivangi kap at 3:40 PM on November 27, 2008
If you want to make changes to an existing trigger, you could use the "ALTER TRIGGER" statements to refine the trigger again. The tutorial exercise below shows you how to modify the trigger defined in a previous tutorial: USE FyiCenterData;GOALTER TRIGGER dmlmessage ON fyiusersAFTER INSERT, UPDATE, DELETE AS PRINT Time: CONVERTVARCHAR12,GETDATE; PRINT Records are inserted, updated
Posted in
Computers & Technology by shivangi kap at 3:40 PM on November 27, 2008
If you dont want to use a trigger any more, you should delete it from the database by using the "DROP TRIGGER" statement as shown in tutorial example: USE FyiCenterData;GODROP TRIGGER newuser;GOSELECT FROM sys.triggersGOname objectid parentid type typedesc ------------ ----------- ----------- ---- ------------dmlmessage 690101499 674101442 TR SQLTRIGGER Trigger, newuser, is deleted now
Posted in
Computers & Technology by shivangi kap at 3:40 PM on November 27, 2008
If want to stop the execution of an existing trigger temporarily, you can use the "DISABLE TRIGGER" statement to disable it. The disabled trigger will be kept in the database. If you want to resume the execution of a disabled trigger, you can use the "ENABLE TRIGGER" statement to enable it. The tutorial exercise below shows you how to disable and enable triggers: USE Fyi
Posted in
Computers & Technology by shivangi kap at 3:39 PM on November 27, 2008
well, A MOSFET flip-flop circuit consisting of a slave circuit formed of a pair of cross-coupled MOSFETs and a master circuit connectable to the slave circuit by the trigger pulse is disclosed pulse length and output pulse interval can be separately regulated over a considerable range of integral numbers of trigger pulses. Several flip-flop circuits can be connected through MOSFET gates
Posted in
Computers & Technology by Nawraj at 8:05 AM on June 26, 2008
a device that activates / releases / causes something to happen...A trigger from the Dutch trekken, meaning to pull is a lever which, when pulled by the finger, releases the hammer on a firearm. In a database, a trigger is a set of Structured Query Language SQL statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs. A trigger
Posted in
Computers & Technology by Ravish Jain at 12:33 PM on March 10, 2008
A device that activates or releases or causes something to happen...trigger is a programming trick which can fire certain activity...Trigger-Which invokes process at certain time...Trigger may refer to:Trigger firearms, a mechanism that actuates the firing of firearms Trigger pad, a device used in electronic percussion Schmitt trigger, an electronic circuit USS Trigger SS-237, a submarine USS Trigger SS-564, a
Posted in
Computers & Technology by quadeer at 10:15 PM on September 10, 2007
Triggers are an action that is performed is a condition is met within the code.In this example, "TRIG56" will perform this action:After a row is inserted into TABLEZZZ, if the row is <=50 theninsert the same row into TABLEYYY. If the condition/value is notmet, the row will not be inserted.You can do a "BEFORE" trigger also. Triggers are code that must be compiled. You can
Posted in
Computers & Technology by shwetasingh at 5:17 AM on November 12, 2008
