adspace


Explain 3 basic parts of a trigger.

Answer Posted / Shyam Sunder

The three basic parts of a trigger are: (1) Event: The event that triggers the execution of the trigger, such as INSERT, UPDATE, or DELETE. (2) Condition: An optional condition that must be met for the trigger to execute. (3) Body: The code executed when the trigger is fired.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current version of postgresql?

1188


What is your daily office routine?

2352


how to start mysql server? : Sql dba

1279


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2100


What is the best sql course?

1063


what are the advantages of sql ? : Sql dba

1154


Is primary key clustered index?

1027


what is sql server agent? : Sql dba

1188


How do I remove duplicates in two columns?

1202


Can we use distinct and group by together?

1146


how to escape special characters in sql statements? : Sql dba

1124


Can delete statement be rollbacked?

1065


what is collation? : Sql dba

1242


Do we need to rebuild index after truncate?

1152


Is primary key always clustered index?

1101