Answer Posted / dhanashree

Running block of code or the querry having opposite
condition placed in the trigger.When the condition gets
false then the trigger gets called avoiding particular
action such as Update,Delete,Insert depending on the
trigger type.The trigger output is in form of Error massage
used in trigger itself.

What is the life of an sql statement?

1076

---

how to enter binary numbers in sql statements? : Sql dba

1012

---

What does pl sql developer do?

982

---

List out the acid properties and explain?

1018

---

What are the syntax and use of the coalesce function?

1275

---

Can a view be mutating? If yes, then how?

1087

---

What is number function in sql?

1018

---

Can we connect to postgresql using sql developer?

1048

---

How do you declare a user-defined exception?

1076

---

How do you identify a primary key?

1113

---

Which kind of parameters cannot have a default value in pl sql?

1212

---

how to analyze tables with 'mysqlcheck'? : Sql dba

1061

---

What are the possible values that can be stored in a boolean data field?

1042

---

how to increment dates by 1 in mysql? : Sql dba

1034

---

Why trigger is used in sql?

1016

---