how to saw triggers output in pl/sql database?
- 1 Answers
- 6585 Views
- I also Faced
- E-Mail Answers
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 |
What is the use of stored procedures?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is the difference between joins?
What are character functions?
how to use in conditions? : Sql dba
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
Why do we need view in sql?
How to avoid duplicate records in a query?
What is self-join and what is the requirement of self-join?
What is the command used to fetch first 5 characters of the string?
What is dbo in sql?
What's the difference between inner join and left join?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
