how to saw triggers output in pl/sql database?
Answer / 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.
| Is This Answer Correct ? | 8 Yes | 5 No |
write sub query for eliminating duplicate rows using analytical function?
What are properties of the transaction?
Can we insert delete data in view?
Can pl sql procedure have a return statement?
What is varchar data type in sql?
What is mutating sql table?
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
What is the purpose of the partition table?
Can a key be both primary and foreign?
What is sql clause?
Does a user_objects view have an entry for a trigger?
what is difference between procedure and function
10 Answers MCN Solutions, Wipro,
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)