which will default fire first
statement level trigger or row level trigger
Answers were Sorted based on User's Feedback
Answer / ram
Before Insert/update/delete triggers executes first..
In this statement level triggers execute first..the order flows as below
Statement level -- before trigger
row level -- before trigger
row level -- after Insert/update/delete triggers
statement level -- after Insert/update/delete triggers
| Is This Answer Correct ? | 0 Yes | 0 No |
how to connect oracle in unix prompt?
what are all the different types of indexes? : Sql dba
What is not in sql?
How does join work in sql?
What is the most important ddl statements in sql are?
How to run pl/sql statements in sql*plus?
what is inline command?
What is trigger in sql and its types?
What is sql and how does it work?
How do you run a query?
What do we need to check in database testing?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
Oracle (3259)
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)