How to call a trigger inside a stored procedure?Give an
example.
- 2 Answers
- 8038 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikandan. s
triggers can't be called from procedures or functions
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / jay
Inside procedure, insert/update/delete the row in table.
The table will automatically fire the trigger. Trigger will
get fire automatically.
| Is This Answer Correct ? | 8 Yes | 2 No |
How to delete multiple rows from a table in oracle?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
Explain the use of ignore option in imp command.
Does oracle database need java?
How to concatenate two text values in oracle?
How to put more than 1000 values into an oracle in clause?
What is the simplest tool to run commands on oracle servers?
Can multiple cursors being opened at the same time?
How to display the hierarchy of employee and managers without using connect by prior.
What are the varoius components of physical database structure of oracle database?
What is a table in oracle?
what is the difference between substr and instr function in oracle?
Oracle General 
