4. Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger?

Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger?

Answer

Cannot perform commit or rollback because they are part of triggering sql statements hence don't need to save the transaction by trigger.

All stored-procedures Questions
Ask your interview questions on stored-procedures

Write Your comment or Questions if you want the answers on stored-procedures from stored-procedures Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---