Learning PL/SQL programming

Download the session ppt here: docs.google.co...
3:05 - Procedures
6:48 - Cursors
15:13 - Functions
16:36 - Triggers
21:35 - Package
23:59 - Exceptions

[@ni12907]

my college lecturer was completely useless, I almost failed my mid exams, dropped the class, this lecturer is so much nicer thanks

[@thekrishnakeshrishow]

college name

[@Thepriyanka2277]

Yeah mee too

[@dora1095]

Me toooo

[@prasangmaheshwari7025]

Bhai hmare yha to aadhe sem lecturer hire hi ni Kiya gya tha..😂🤦

[@mukulprasadray7532]

God bless you sir. Can't believe you covered all important topics in 30 minutes only.

[@BBarters]

I am glad it was useful.

[@omkarmore7017]

Seriously that was what we needed. A short time basic understanding of syntax, flow,etc Thanks barter

[@friktogurg9242]

@@BBarters I seem to have created a function that returns multiple rows of string value, how do I read the return value of the function? Or is that not allowed in a function?

[@ayushbhardwaj6783]

best abstract of PL/SQL in 30 mts. Helped me a lot. Thankyou.

[@BBarters]

Most welcome!

[@dylanlepage7524]

This is a great tutorial! Props from Quebec, Canada!

[@sahibpreetsingh3065]

well, I haven't gone through other content of this creator but this single video won my subscription. Thank you BBarters.

[@vishaldivekar903]

Thank you Sir, Really good video for PL/SQL learner, as you really covered each and every topic along with theory and practical, within such a short span of time . Unlike other channels u have not wasted time on explaining same thing.

[@mayanksinghal6261]

Concise and optimized tutorial. All topics covered in short with necessary points. :)

[@alphamichelangekalinganire8898]

U re a time-saver, a whole module in 30min, u did great job thank u

[@BBarters]

Glad it helped

[@rinapulli4888]

Your explanation is best among all available videos on KZbin. Great work keep it up. Subscribed and liked..

[@ayushbhardwaj6783]

Best explanation of PL/SQL in 30 mts. Amazing. Keep it up man...!!! THankyou

[@AI-Artist-]

Covered my complete PL/SQL syllabus in 30 mins!

[@Ather178]

Good content for brush up if you are already aware of these concepts. Thanks for sharing.

[@deeptyrajput8343]

Crystal clear explanation,covered each important corner.Thank you .

[@SinskariBoi3366three]

I want to live peaceful life and have a successful career in IT. I’m what I’m because I never had a very strong foundation of anything until high school. During engg i developed interest and knowledge in database and work with small companies to gain hands on experience. I build a very strong profile and now I’m aiming to get my pr based on my profile and get engaged in my job.

[@BS-vk2sd]

Sir Thank You so much you're a savior for me.

[@prasanna.ltimindtree]

Wonder ful explaination..! well done Barters..Appreciated your job❣❣❣❣

[@SinskariBoi3366three]

Great Tutorial "When others then null" is the king :D But, if I may, another very important thing which is often ommitted - one should log into the log table the key data for the process e.q. - the client id, the phone number or whatever you will later looking for... What's more - logs tables usually are big or very big. If you direclty choose the key data and key fields for searching -it would be easer to create an index. Too many times I saw very perfectly built logs but without easy to retrive information about the key data - or no information at all or hidden in the text field! Queries on example tables look like that: 1. find max id from the log table 2. search for rows where id > max - 10000 (id as the only filed with index!!) 3. search by your eyes for errros or try to use MESSAGE_FILED LIKE '%my_client_nr%'

[@mohankumar-kz7fz]

Quick and to the point explained. Good job.

[@elghoulghazi3436]

Full course explained in 30 min and at schools this lasts for 3 months minimum , just Great.... and they still insist that the educational system is good xD Gj and thank you

[@BBarters]

Great to hear! Glad to be of help!

[@user-g3r2d]

thank you so much, my lecturer, is completely incompitent

[@ravisb7527]

Nicely explained. Covered all major topics of plsql course. Thanks

[@yizhiw]

great overview of PL SQL. Thanks.

[@ltobva]

I've heard this before so maybe it was just the next time, but all of a sudden, everything you said in this tutorial just makes it all seem obvious and easy. Thanks so much.

[@rukshanarizyan7931]

Having my exams tomorrow and this helped me soo much,Thank Youu sir

[@abhishekanand4152]

man, you saved the day :)

[@prabhat123456789]

basics of pl/sql has been explained very well. Thanks a lot

[@shilparai8274]

Very informative for beginners, appreciate the efforts

[@DsiakMondala]

This is rich and very concise. I just wish the code was properly formatted.

[@chandramiryala]

Great job sir, you have explained very well. Can you explain any project which one is related to the PL/SQL . It is a request. Thank you.

[@giuseppeardito]

Thank you for this video. It's been extremely helpful!!

[@MissButterflie-ShreyaMishra]

Great video man ...just the right information i needed 👏

[@pritam9958]

In beginning it has said that "why do we need plsql?" For lopping,if else condition ,is it not possible in sql? thn what for using case scenario in sql are we not using lopping if else? According to me not a correct definition

[@the_kiran_chowdary]

Any one having this pdf please send with me urgently

[@arun06530]

Nice and concise video tutorials for beginners and clearly explained the topics with demo.

[@hasanmusaj4876]

Very useful tutorial. Thank you very much!

[@poppybelle23]

Hoping this gets me through my exam later today😂😅

[@sarishri5084]

Thank you! Wonderful video 😊

[@BBarters]

Glad you enjoyed it!

[@NaveenKumar-yp6qw]

Which software did you use sir??

[@madhavikatta7346]

Sir thank you so much you save my day. Very great lecture. No words to describe about your teaching skills Sir one small request how to practice sql to get command . Plz guide me

[@StoryPuzzles]

great lecture , save a lot of time

[@dineshshinde7642]

Nice video..Short n simple👍

[@aravind7627]

great work. thanks much

[@MayukhDatta]

Can we modify the second example of explicit cursors to display top 2 earners in each department? Kindly reply.

[@divyakamath2320]

thank you , saved me :)

[@yeassinchowdhury3645]

Why do we increment after dbms.putline and not before?

[@haripriyaram7924]

Great Video and Very Insightful

[@aminzaiwardak6750]

thanks a lot sir,useful video which clear my doubt

[@ramaprakashreddyvardhiredd2129]

Hi can Please how to pass list as a i/p variable in stored procs

[@shilpaingole770]

Very well explained

[@divyam69]

Thank you so much sir :)

[@brunocarvalho1718]

thank you I learned a lot

[@suryakant.gawande05]

Thank you sir. you have explained very well.

[@mayankdandhare3342]

Thank you so much Sir!

[@BBarters]

Most welcome!

[@LifeReadiness]

Thank you very much sir for this awesome video. All my doubts are now cleared.

[@asnakhan9115]

Thankyou so much sir thankyou so much life saver!!!

[@SinskariBoi3366three]

Good tutorial for the brush up

[@AMITAS5]

very nice and concise video on PL/SQL

[@mohakmohan]

Great video sir. Very helpful 🙌

[@CoolDuderohitsrivastava]

I want to know which IDE is used to do coding and from where I can easily download it. Can you provide any link to download that IDE?

[@yuganshukumar7068]

you need to download oracle brother.

[@albertosoto4280]

look for oracle application express (apex)

[@fabianrr]

Please make same tutorial, but using the HR scheme 🙏.

[@mahinhasan474]

can anyone give me the tables for the above query?

[@shyamtripathi8276]

Where can I get lots of practice exercises for PL/SQL

[@shwetagupta9971]

sir what does New.email does?? basicaly i have never user new?

[@keerthik2993]

Hello Sir, I want to learn pl/sql programming. Could u please tell me how can I contact you for the same?

[@honeypatre]

Very Very nice and informative

[@BBarters]

Glad that it was helpful to you.

[@mastanvalishaik5580]

Great tutorial, Thank you sir.

[@ankitabogam6841]

Does any one have above PPT? I want to download it

[@skkhadeer3558]

How to install Oracle database expression edition

[@razaulkarim9537]

This is very good for new learner

[@lurajeni2426]

Very good explanation..thumbs up

[@jadapallidhanush1350]

Bro nen civil 2014 passed out, present nen software side velladaniki veeluntunda, unte am cheyyalo avaraina cheppagalara plz....

[@wisdommania555]

really fantastic class.

[@hyme6691]

I love you, thank you so much

[@shivangiupreti9112]

Really nice Tutorial..Thank you so much

[@BBarters]

Glad it was helpful!

[@ayushp8790]

Thank you deer

[@nishisharma730]

Excellent

[@ankithanaik6011]

How to write the query to (select name who is getting maximum annual salry )...if i know only monthly salary.

[@khaleddaabees6121]

SELECT NAME FROM TABLE1 WHERE SALARY = (SELECT MAX(SALAR) FROM TABLE1)

[@imanearhsai4265]

thank u it was so helpful to me

[@nareshkoude6426]

very useful for beginners,Thanq

[@bilalahmadtaj4295]

Nice Tutorial

[@teeahtate]

Thank you

[@wakeelsah9434]

Very helpful video... thank you sir...

[@rohit_raj-it-2nd_yr-a-287]

Ppt is not opening . It's asking for permission.

[@Subversion123]

this video was Pog

[@fxsignal1830]

grazie mille!

[@maddulamanohar2888]

Thanq so much :)

[@subbugentleman]

Excellent tutorial

[@sonalikamat8176]

bbarter you did great job.

[@nikhatsaba7809]

Hi Sir, Can i get the link where some more videos are uploaded with more programming examples code. I wanted the codes for practicing. This video help me a lot. Please help me with the others also. Regards, Nikhat

[@BBarters]

Hola Nikhat, will be uploading more videos (programming specially) on this channel soon. Please subscribe for the same.

[@nazmulhaque6674]

helloo, did u working in oracle till now , how can be advance in oracle give suggestion ....

[@studyingdelights5458]

Nikhat Saba Hi..if u get more videos plz share wid me....

[@ADITYA_1303]

Helped a lot 😁❤

[@nehakapoor7906]

I want this ppt can you please provide it if possible.Thank you for clearing concept clearly.

[@nehakapoor7906]

Please revert me

[@rashmikolluru]

Awesome video.

[@RohitKumar-bu4pm]

Thanks you sir....

[@sethumadhavdoredla3823]

Just explain each one a bit more

[@nethrasatya3221]

very nice explanation sir... helped me a lot....

[@randomtubebangla4867]

These topics are enough na?

[@debashreedas3819]

Just Awesome

[@Draxper]

amazing tutorial

[@SVP_003]

i just wanna rock -lil uzi vert

[@shaheenshaikh6701]

Sir what's d difference between procedure n function plzz answer!

[@unityaboriginelove6595]

procedure- may or may not return a value. A function ALWAYS returns a value.