Oracle PL SQL interview question | DML DDL TCL commands in Procedure Function and Trigger |Oracle DB

Oracle PL SQL interview question | DML DDL TCL commands in Procedure Function and Trigger |Oracle DB 1. ORACLE PROCEDURE VS FUNCTIONS https://youtu.be/CkkIbsi_3cc 2. Can we use DML and DDL statements inside function?(Part1) https://youtu.be/yyRM-p2xfZc 3. Can we use DML and DDL statements inside function?(Part2) https://youtu.be/CGLWDytoUeE 4. What is pragma autonomous transaction? https://youtu.be/OK7KA99plXQ 5. use cases of pragma autonomous transaction https://youtu.be/R4dyvrVC9t0 00:00 Introduction 01:12 Demo1 - DDL in Procedure 02:57 Demo2 - DML in Function 05:08 Demo3 - TCL in Trigger 06:39 Summary - DML/DDL/TCL in Procedure 06:52 Summary - DML/DDL/TCL in Function 07:56 Summary - DML/DDL/TCL in Trigger 08:36 Videos for further learning 09:12 Thank you -------------------------------------------------------------- This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies. https://www.youtube.com/SivaAcademy Home page: https://sivakacademy.blogspot.com/ Telegram Channel : https://t.me/SivaAcademy -------------------------------------------------------------- Home page: https://sivakacademy.blogspot.com/ List of all oracle SQL/PLSQL Interview questions https://sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html List of all PLSQL Scenario based Interview Questions https://sivakacademy.blogspot.com/p/plsql-scenario-based-interview-questions.html List of all Subscriber questions and answers https://sivakacademy.blogspot.com/p/all-subscriber-questions-and-answers.html -------------------------------------------------------------- Oracle Interview questions playlist https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features playlist https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features playlist https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections playlist https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm -------------------------------------------------------------- My video courses at UDEMY https://www.udemy.com/user/2c29d781-3879-41b5-a304-ea8325f15806/ -------------------------------------------------------------- About Myself: ---------------------- I am Siva, [LEARN | CODE | TRAIN | SHARE]. Being in IT industry for more than 12+ years. In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX. I am passionate about "DATA", coding & training. In my spare time, I teach database technologies , ETL etc. I am very glad that you are reading my Profile, and I value your time as well as mine. Looking forward to see you in my videos For any questions, please drop me a mail at [email protected] --------------------------------------------------------------