Oracle PL SQL interview question | oracle pragma autonomous transaction real time use case

Oracle PL SQL interview question | oracle pragma autonomous transaction real time use case

Function with DML/DDL Video links given below

#oracle interview questions and answers
---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 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

---------------------------------------------------------------------------------------------------------------------------

[GautamKumar-cirz]

Hi Siva, I don't have words to thank you. I got new job in this covid situation by listening to your videos. Just want to say that you are doing a fantastic job . God bless you always .

[nareshreddy]

What a explanation sir. You are king of SQL $ PLSQL it's my opinion sir

[devanaidu]

Hi Sir, you are the best faculty for SQL and PLSQ sir, I have never seen this kind of explanation, thanks a lot for sharing your knowledge us..with free of cost..you are kind person..thank u sir.. please Keep continue sir 😊

[aartheesiva]

One of the best real time explanations about the pragma exception. Really good work🎉

[ramkumar]

We can use rollback right after when clause and commit after insert statement in the exception block right. But, thanks for you clear explanation about autonomous txn.. Loved your work ❤

[swamivivekananda-cyclonicm]

Awesome. Superb. Undisputedly you deserve most KPM Award - (Knowledge per Minute. Award)

[nk]

@siva academy: You are doing amazing work and helping us to understand concepts clearly. Thanks a lot

I have a question on using pragma autonomous transaction in triggers. Please explain in what scenarios we need to use commit in triggers

[RaxTubeYou]

Amazing videos, you are really clear, informative and excellent at explaining the details without so much confusion. Brilliant thanks

[venkatapothuri]

Thanks to Siva Academy folks making these videos, they are crystal clear..
If we need to million rows to get inserted .. and a couple of thousand rows fails.. how do we capture the INSERT STATEMENTS which gets failed besides the SQL errors and error msgs you have explained ?

[anupdeshmukh]

Very informative, keep it up and provide us more and more knowledgable videos.

[shashank]

As always awsome explanation... I am eagerly awaiting your performance tuning videos

[vinu]

Hi Siva,
Thanks for the transparent covering of the topics. I would request you to Share the reference link like in this video you indicated to go through 13 Part 1 & Part 2. If you tell the same link has been given in the description, it will be easy for the users to navigate the supporting videos..!!

[sairamtheexplorer]

Thanks for the very useful interview questions, these were the questions I faced in my initial stage, but at that time, I missed your videos.
Anyway very informative and useful.Thank You :)

[rameshramajayam]

Great Explanation.... Awesome ...Keep Upload more videos ..

[karthiarumugam]

No words to say about your videos. Very very useful and clearly explained what is expected by everyone and interviewer...I have not seen these kind of videos ever before...
Any plan to upload Unix videos?

[arijitroy]

Thnx a lot buddy for such a lucid explanation. Could u pls explain further what oracle internally does when we use pragma in triggers having commit/pragma in a function containing DML Being used in a select query.
Thanks.

[mohammadfazil]

Super siva sir.. Will wait for your upcoming videos..

[dkoothan]

Great sir.. Aswome explanation...I'm requesting you to kindly post video for how to debug the procedure which has more than 3k line nd calling different procedures... Thanks in advance...

[rajivshivaraman]

Thank You So Much Siva Sir clear explanation.

[rahitbasu]

Thank you so much sir..please share some Functional video on oracle Finance module