Hello Sir , I am oracle Forms / Reports developer, Your video help me a lot to solve PLSQL concepts. Voice clarity is super clear, Easily we can grasp concepts. Thank you for making and sharing valuable knowledge.
Subscriber reply question series having most of the the SQL practical interview questions, also seperate playlist available specifically for SQL practical scenario based question
Helo Bro I am a Forms / Reports developer, and one of my friend referred your channel then i go through the series. i got amazing result and concept is very clear now. thank you for your valuable time. best of luck bro.
Well explained.. I have another scenario.. What happens if the autonomous transaction has insert into a different table trying to get commit is LOCKED. As per your explanation until autonomous transaction did not get committed, the control will not return to parent transaction. Is this means your PL-SQL block gets hungup.. If so, how we can find it ( either as DBA or Developer )
Could you please make a video on resume the PL/SQL code. I mean the plsql program error occurred on some place, after fix the code need to start from that place.
Hi sir , The video is very informative I have a question regarding this Suppose I have a insert statement followed by create statement and then followed by 2 insert statement if I rollback the transaction what would be the output
DDL statment would automatically commit any transaction happened before, hence only last two inserts will get roll backed keeping the first insert committed
Thanks a lot sir for elaborations. Sir just want to know could we use this in row level trigger to avoid mutating error while writing SQL queries on same table on which trigger can be written. Please advise.
There is a table have a record with numeric and alphabet in a single row, result wants to display number in one row and alphabet in another row? How it is Bro
Hello Sir , I am oracle Forms / Reports developer, Your video help me a lot to solve PLSQL concepts. Voice clarity is super clear, Easily we can grasp concepts. Thank you for making and sharing valuable knowledge.
Its my pleasure, thank you for your comments 🙏💐💐💐
This is best the learning channel i found so far.Simplifying the concepts.Pure gift you have Sir...
Its my pleasure 💐, thank you for your comments
@@SivaAcademy Also Sir is there a separate playlist for SQL interview questions? I couldn't find so far. Kindly guide.
Subscriber reply question series having most of the the SQL practical interview questions, also seperate playlist available specifically for SQL practical scenario based question
Nobody has explained this better than you. Thanks a lot.
Welcome bro
The ultimate source of learning
Thank you 🙏💐
Very good explanation thank you sir requesting from you machine learning classes
Helo Bro
I am a Forms / Reports developer, and one of my friend referred your channel then i go through the series. i got amazing result and concept is very clear now. thank you for your valuable time. best of luck bro.
Welcome bro, thank you for your comments, please stay tuned for more videos
How clearly you explain the concepts sir..Thank you so much for this explanation I'm glad i came across your channel😊
My pleasure, thank you 💐
Well explained..
I have another scenario.. What happens if the autonomous transaction has insert into a different table trying to get commit is LOCKED.
As per your explanation until autonomous transaction did not get committed, the control will not return to parent transaction. Is this means your PL-SQL block gets hungup.. If so, how we can find it ( either as DBA or Developer )
Really Good.. waiting for this.. Thank you sir
Welcome :-)
Brilliant explaination ❤️
🙏Thank you
Could you please explain the unix overall process and command and real time uses. Etc
Yeah please stay tuned
simply best ,awsm bro
Welcome bro 🙏
You makes topic so easy to understand. Grateful for all your efforts.
Thank you bro 🙏
so daam helpful, Thank you so much God bless
welcome bro
perfect explanation sir ,
Thank you so much it's really helpful and the way you explaining is neat and clean
My pleasure, thank you
Could you please make a video on resume the PL/SQL code. I mean the plsql program error occurred on some place, after fix the code need to start from that place.
Crystal clear concept explanation👍
Welcome 🙏👍👍💐
Thanks Siva...
Thanks siva sir . This satvinder . I did so many time request for this video. Finally you did . I got my point why we use pragma autonomous
Sorry for posting late, since there were many pending questions I was not able to post earlier, glad that it helped, welcome 🙏
Siva Academy no it is not late
Are you providing aws and devops classes
No, not righ now
All your videos explanations are very clear and easily understood... :)
Welcome 🙏
Thank you so much, this video very useful, have follow-up this channel
Welcome bro
Simply superb bro , the way you explain the concepts 👌👌👌👌
Its my pleasure thank you 🙏💐
Very clear explanation....thanx
You are welcome
thanks bro .. great lesson !!!!
Welcome bro
Great Content Siva
Thank you bro
What a explanation...wow wow
Thank you
suppose if block of program with autonous trasaction take 5 minutes to execute, will it affect the main program execution. ?
thank you very much for this nice video.....
My pleasure bro, thank you
So clear.. Thank u sir
Welcome
Great explanation 👌
Thank you 🙂
thankyou so much ..❤❤
You're welcome 😊
What is the use of rollback or savepoint inside pragma autonomous transaction program? It is of no use ?
Excellent, thank you very much
Welcome, thank you
Awesome. thanks.
Welcome
Interesting
is there any video on query optimization?
Yet to post, please stay tuned
Thanks man
Thank you... 👍
Welcome bro
Hi sir ,
The video is very informative
I have a question regarding this
Suppose I have a insert statement followed by create statement and then followed by 2 insert statement if I rollback the transaction what would be the output
DDL statment would automatically commit any transaction happened before, hence only last two inserts will get roll backed keeping the first insert committed
Thanks a lot sir for elaborations. Sir just want to know could we use this in row level trigger to avoid mutating error while writing SQL queries on same table on which trigger can be written. Please advise.
Welcome 🙏, sure please stay tuned
Please share video link regarding estimate/compute statistics in performance tuning.
I am yet to post on this topic, please stay tuned
If you executed the procedure already u have created and results will be get stored in Tables how it is?
Can you please elaborate your question
I want to run a plsql, it should start two parallel plsql block..is it possible...??
Yes you can do using dbms scheduler, I will try to post a video soon, please stay tuned
Waw explanation
Thank you
good sir
Thank you
If entire parent transaction will be rolled back then what will happen to Create Table statement, as that is also in parent transaction?
DDL are autocommit statement, hence anything before create table will get automatically commited
@@SivaAcademy thanks 🙏 subscribed your channel
Welcome 🙏💐
There is a table have a record with numeric and alphabet in a single row, result wants to display number in one row and alphabet in another row? How it is Bro
Please look into this video, your question is very similar to this
th-cam.com/video/ZuO8QmnzpdY/w-d-xo.html
Sir can you explain for mutating table error with pragma autonmous transaction concept
Sure please stay tuned
Hi Siva,
Could you please create a video on Piepline table functions
Thanks
Sure Vishal, will add into upcoming list, please stay tuned