How to call a trigger inside a stored procedure?Give an
example.
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 difference between Delete, Truncate and Drop in Oracle?
How do we create privileges in oracle?
When do we use group by clause in a sql query?
How to work with data objects interactively?
What is the data pump export utility?
What is a nested table and how is it different from a normal table?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the attributes of the cursor?
What are the differences between interval year to month and interval day to second?
How can windows applications connect to oracle servers?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Differentiate between function and procedure in oracle.
How to create a table interactively?
How to start an oracle instance?
Can you assign multiple query result rows to a variable?