How to call a stored procedure inside a trigger? Give an
Answer / pardeep
Using Call keyword we can call procedure inside trigger.
CREATE OR REPLACE TRIGGER foo
BEFORE DELETE OR INSERT OR UPDATE ON <<table_name>>
FOR EACH ROW
|Is This Answer Correct ?||15 Yes||3 No|
Select the Nth lowest value from a table?
What is a read only transaction in oracle?
What do you know about normalization? Explain in detail?
What is a nested table?
How to delete a user account in oracle?
How would you go about verifying the network name that the local_listener is currently using?
Which is better Oracle or MS SQL? Why?
What is a View ?
What are the roles of dba?
Please explain oracle data types with examples?
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
Can a property clause itself be based on a property clause ?