Top PL/SQL Tips In Just One Hour

[@TheRealBigYang]

22:00 Even in my university projects I always have a separate file with just my sql statements, safely stored into functions, making a little library of database manipulation code. I don't need to change every single line of code, I just change that little database functions library.

[@zexalex]

bulks are meant for performance. but in the vast majority of use cases, simple and clear code is always a better option, despite the performance drawback.

[@PracticallyPerfectPLSQL]

That's a great point, Zex - as long as the performance drawback doesn't cross a red line for users. So here's how I would rephrase your comment: Software needs to be FAST ENOUGH for users not AS FAST AS POSSIBLE. So don't perform unnecessary optimizations that make your code complex and hard to manage. What do you think? :-)

[@letsvisualizedata5106]

It is one of the best PL/SQL tutorials I have found in the youtube form the point of view of performance. Can you please create a tutorial on AWR report?

[@PracticallyPerfectPLSQL]

I am not the guy to go to for an AWR tutorial, sorry. :-(

[@oracledevs]

Thanks, but I am not the guy to do a tutorial on AWR. I will pass it along.

[@yotuberudy85]

result_cache is what called memoization in many other languages

[@dhanukajayasinghe9598]

Steven, thanks champ. You just helped me clean up my immature code. Keep up the good work...

[@dhanukajayasinghe9598]

And appreciate if you could do a lesson on Cursors..

[@eugenek951]

Enjoyed it!

[@worldrenownedastrologer]

Thanks

[@bbujjin3899]

Always loved this channel my favourite you tube channel

[@SinskariBoi3366three]

MI was caught in the trap here, it is still unclear to me. Sorry, I started to feel silly. When I executed in Toad it returned Count=4. But still when I read it, I don't get it how it returned 4. Can you elaborate it or can you make an other post on this please. In the function: store_and_return_date --#1. First call to insert into the Collection: dates with parameter's SYSDATE add_date (date_in); IF call_in_plsql_in = 'YES' THEN --#2.Second call to insert into the Collection: dates, with SYSDATE current add_date (SYSDATE); END IF; Since the table: tab has got 4 rows, what impact does it make while calling functions with parameter (call_in_plsql_in=YES/NO).

[@kopanoramaphoi6050]

Well articulated

[@nviknesh8112]

You are great... 🙏

[@thuongthuong773]

Thank you so much

[@Empire_Earth]

Are you gonna reupload this videos with the screen fix?

[@oracledevs]

It is fixed, so far as I know.

[@EugeneKogan-e8z]

Genius!

[@jay75210]

Awesome

[@michelealbanese4438]

Wow