How to call a trigger inside a stored procedure?Give an
example.
- 2 Answers
- 8406 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of oracle?
Differentiate between function and procedure in oracle.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Explain implicit cursor.
Is there an oracle sql query that aggregates multiple rows into one row?
What is a view and how is it different from a table?
How many types of table in Oracle?
What is an oracle cursor variable?
Explain the function of optimizer in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Explain about your project and its relation to the current job position you are applying to?
what are bitmap indexes? How does they work?
Is there a combination of "like" and "in" in sql?
How will you differentiate between varchar & varchar2?
How to return top 5 rows in oracle?
