Thanks for the question, amit.
Asked: June 07, 2017 - 5:50 am UTC
Last updated: June 07, 2017 - 10:38 am UTC
Version: 11g
Viewed 1000+ times
You Asked
Hi,
my Question is
1) i have a statement level trigger and row level trigger on the same table
but i want to update some date on the same table i finished my update
then i select to see the data which has updated but output is no rows select.
2) here is what will be the output?
3) which trigger will execute ist and why and how ?
4) what will be the output if i will write a select query ?
Hope you will give answer as soon.
and Connor said...
"i have a statement level trigger and row level trigger on the same table"
Not that we can see.
"here is what will be the output?"
We have no idea...we can't even see the table or the trigger...
"which trigger will execute ist and why and how ?"
Probably the statement one...but you provided no code, no test case, no details... so its a mystery.
"what will be the output if i will write a select query ?"
Depends on the query probably. If you write
select 1 from dual
you will get "1" back.
If you write
select username from dba_users where user_id = 0
then you will get "SYS" back
But you're not limited to just those queries...
Sigh
Is this answer out of date? If it is, please let us know via a Comment