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..😂🤦

[@aditya_k43]

Same here man 😢

[@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?

[@sahibpreetsingh3065]

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

[@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!

[@prasanna.ltimindtree]

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

[@alphamichelangekalinganire8898]

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

[@BBarters]

Glad it helped

[@mayanksinghal6261]

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

[@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.

[@ChakradharVangara]

Good refresher in 30 minutes. Thanks for putting this together.

[@Ather178]

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

[@fabianramoscarrillo7626]

🎯 Key Takeaways for quick navigation: 00:00 🌐 Introduction to Change Management - Thijs Homan's expertise in change management and his unique perspective. - Emphasis on managing change in a dynamic and complex environment. 02:30 🔄 Change Happens Regardless of Management - Acknowledgment that change occurs irrespective of formal change management efforts. - Importance of recognizing and adapting to change as an inherent part of organizational dynamics. 05:45 ⚖️ Contemplating Undefined Concepts - Exploring the concept of 'undefined' elements in organizational change. - Discussing the need to accept ambiguity and complexity in change processes. 08:14 🤹‍♂️ Balancing Control and Adaptability - Highlighting the paradox of wanting to control change while acknowledging its unpredictable nature. - Encouraging a balance between planned interventions and allowing organic change to unfold. 11:32 🌊 Understanding the Cloud of Meanings - Introducing the concept of the "cloud of meanings" in organizational change. - Emphasizing the role of collective interpretations and perspectives in shaping change processes. 14:39 🛠️ Tools and Techniques in Change Management - Addressing the limitations of traditional change management tools and techniques. - Encouraging a more nuanced approach that considers the complexity of organizational dynamics. 18:35 🔄 Embracing Inevitable Change - Reinforcing the idea that change is inevitable and cannot be entirely controlled. - Encouraging a mindset of adaptability and responsiveness to change in organizations. 21:57 🚀 Shifting Perspectives on Change Management - Advocating for a shift in perspective towards change management as a complex, multi-dimensional process. - Highlighting the importance of considering various viewpoints and interpretations in managing change. Made with HARPA AI

[@gobijacques]

dogshit ai

[@AI-Artist-]

Covered my complete PL/SQL syllabus in 30 mins!

[@deeptyrajput8343]

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

[@rinapulli4888]

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

[@detrom.h1819]

i find all i need in this video about pl sql ,thank you so much

[@ayushbhardwaj6783]

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

[@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.

[@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.

[@BS-vk2sd]

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

[@ravisb7527]

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

[@mohankumar-kz7fz]

Quick and to the point explained. Good job.

[@athirasasidharan6024]

thankyou so much for saving me from exams! you are great

[@user-g3r2d]

thank you so much, my lecturer, is completely incompitent

[@prabhat123456789]

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

[@rukshanarizyan7931]

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

[@yizhiw]

great overview of PL SQL. Thanks.

[@giuseppeardito]

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

[@shilparai8274]

Very informative for beginners, appreciate the efforts

[@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!

[@MissButterflie-ShreyaMishra]

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

[@arun06530]

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

[@abhishekanand4152]

man, you saved the day :)

[@hasanmusaj4876]

Very useful tutorial. Thank you very much!

[@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

[@harshal9926]

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%'

[@aminzaiwardak6750]

thanks a lot sir,useful video which clear my doubt

[@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.

[@haripriyaram7924]

Great Video and Very Insightful

[@suryakant.gawande05]

Thank you sir. you have explained very well.

[@dineshshinde7642]

Nice video..Short n simple👍

[@hyme6691]

I love you, thank you so much

[@SinskariBoi3366three]

Good tutorial for the brush up

[@LifeReadiness]

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

[@DsiakMondala]

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

[@aravind7627]

great work. thanks much

[@mohakmohan]

Great video sir. Very helpful 🙌

[@mayankdandhare3342]

Thank you so much Sir!

[@BBarters]

Most welcome!

[@Random123-i1e]

Thank you!

[@itz_a_secret1226]

9Q.Write PL/SQL code that prompts the user for an integer representing a month (1 for January, 2 for February, etc.). Based on the month number, print the name of the month. If the number is not between 1 and 12, print "Invalid month number". Code:- DECLARE monthNum number := &monthNum;BEGIN CASE monthNum WHEN 1 THEN DBMS_OUTPUT.PUT_LINE('January.'); WHEN 2 THEN DBMS_OUTPUT.PUT_LINE('February.'); WHEN 3 THEN DBMS_OUTPUT.PUT_LINE('March.'); WHEN 4 THEN DBMS_OUTPUT.PUT_LINE('April.'); WHEN 5 THEN DBMS_OUTPUT.PUT_LINE('May.'); WHEN 6 THEN DBMS_OUTPUT.PUT_LINE('June.'); WHEN 7 THEN DBMS_OUTPUT.PUT_LINE('July.'); WHEN 8 THEN DBMS_OUTPUT.PUT_LINE('August.'); WHEN 9 THEN DBMS_OUTPUT.PUT_LINE('September.'); WHEN 10 THEN DBMS_OUTPUT.PUT_LINE('October.'); WHEN 11 THEN DBMS_OUTPUT.PUT_LINE('November.'); WHEN 12 THEN DBMS_OUTPUT.PUT_LINE('December.'); ELSE DBMS_OUTPUT.PUT_LINE('Invalid month number.'); END CASE; END; /

[@divyam69]

Thank you so much sir :)

[@StoryPuzzles]

great lecture , save a lot of time

[@artianrika8329]

thanks, very helpful

[@brunocarvalho1718]

thank you I learned a lot

[@shivangiupreti9112]

Really nice Tutorial..Thank you so much

[@BBarters]

Glad it was helpful!

[@divyakamath2320]

thank you , saved me :)

[@itz_a_secret1226]

CONTROL STR. Q1. Write PL/SQL code to print even numbers from 1 to 10(CONTINUE WHEN) CODE:- DECLARE i NUMBER; BEGIN DBMS_OUTPUT.PUT_LINE('THE EVEN NUMBERS BETWEEN 1 TO 10 IS :'); FOR i IN 1..10 LOOP IF MOD(i, 2) = 0 THEN DBMS_OUTPUT.PUT_LINE(i); END IF; END LOOP; END; /

[@asnakhan9115]

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

[@wisdommania555]

really fantastic class.

[@mastanvalishaik5580]

Great tutorial, Thank you sir.

[@razaulkarim9537]

This is very good for new learner

[@itz_a_secret1226]

Q2.Write PL/SQL code that prompts the user for two integer inputs, N1 and N2. If N1 is greater than N2, print "N1 is greater than N2" along with their product. Otherwise, print "N1 is not greater than N2" along with their sum. CODE:- DECLARE N1 INTEGER; N2 INTEGER; BEGIN N1 := &N1; N2 := &N2; IF N1 > N2 THEN dbms_output.put_line('N1 is greater than N2'); dbms_output.put_line('The product is ' || N1 * N2); ELSE dbms_output.put_line('N1 is not greater than N2'); dbms_output.put_line('The sum is ' || (N1 + N2)); END IF; END; /

[@aiswaryas]

found really helpful. Thank you.

[@poppybelle23]

Hoping this gets me through my exam later today😂😅

[@debashreedas3819]

Just Awesome

[@honeypatre]

Very Very nice and informative

[@BBarters]

Glad that it was helpful to you.

[@shilpaingole770]

Very well explained

[@teeahtate]

Thank you

[@AMITAS5]

very nice and concise video on PL/SQL

[@BATMAN2003-t9j]

Helped a lot 😁❤

[@nishisharma730]

Excellent

[@itz_a_secret1226]

10Q.Write PL/SQL code that prompts the user for two integer inputs, N1 andN2. If N1 is greater than N2, print "N1 is greater than N2" along with their product. Otherwise, print "N1 is not greater than N2" along with their sum. Code:- DECLARE N1 number := &N1; N2 number := &N2; BEGIN IF N1>N2 THEN DBMS_OUTPUT.PUT_LINE(N1 || ' is greater than ' || N2 || 'Therefore their product is : ' ||N1*N2); ELSIF N1

[@fxsignal1830]

grazie mille!

[@lurajeni2426]

Very good explanation..thumbs up

[@maddulamanohar2888]

Thanq so much :)

[@kavyajaswani1801]

u r a hero👍👍👍

[@ed1849x]

Thank you!!

[@subbugentleman]

Excellent tutorial

[@nareshkoude6426]

very useful for beginners,Thanq

[@wakeelsah9434]

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

[@imanearhsai4265]

thank u it was so helpful to me

[@Subversion123]

this video was Pog

[@itz_a_secret1226]

Q7. Write a PL/SQL Code Using the GOTO Statement (Displaying values from 1to 5) CODE:- declare counter number :=1; begin loop DBMS_OUTPUT.PUT_LINE('value is:'||counter); counter:=counter + 1; IF counter>5 THEN GOTO end_loop; END IF; END LOOP; DBMS_OUTPUT.PUT_LINE('loop ended'); END; /

[@ayushp8790]

Thank you deer

[@itz_a_secret1226]

8Q.What does the GOTO end_of_program; statement do in the followingPL/SQL block . CODE:- DECLARE num number := 8; BEGIN IF MOD(num,2)=0 THEN DBMS_OUTPUT.PUT_LINE('The number is even.'); GOTO end_of_program; ELSE DBMS_OUTPUT.PUT_LINE('The number is odd'); END IF; DBMS_OUTPUT.PUT_LINE('End of the program.'); END; /

[@ramaprakashreddyvardhiredd2129]

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

[@bilalahmadtaj4295]

Nice Tutorial

[@RohitKumar-bu4pm]

Thanks you sir....

[@sonalikamat8176]

bbarter you did great job.

[@mounadifatimazahra3647]

Great video!

[@itz_a_secret1226]

Q3.Write a pl/SQL program to accept marks from the user and display hisclass Code: DECLARE marks number:=&marks; BEGIN CASE WHEN marks>=90 THEN DBMS_OUTPUT.PUT_LINE('Excellent'); WHEN marks BETWEEN 70 AND 89 THEN DBMS_OUTPUT.PUT_LINE('pass with class B'); WHEN marks BETWEEN 50 AND 69 THEN DBMS_OUTPUT.PUT_LINE('pass with class C'); WHEN marks

[@leepakshiyadav1643]

amazing video :)

[@Draxper]

amazing tutorial

[@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

[@yashshreeshinde4394]

Thank you!!!!!!

[@itz_a_secret1226]

Q4. Write a PL/SQL code Loop Exit query.(WHILE LOOP) CODE:- DECLARE a number(2):=1; begin while a

[@nethrasatya3221]

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

[@jadapallidhanush1350]

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

[@skkhadeer3558]

How to install Oracle database expression edition

[@itz_a_secret1226]

Q6.Write a PL/SQL code to calculate total and percentage of marks of the students in four subjects CODE: DECLARE Physics number := 78; Chemistry number:= 88; Maths number := 79; Biology number := 92; Total number; Percentage float; BEGIN Total := Physics + Chemistry + Maths + Biology; Percentage := Total/400*100; DBMS_OUTPUT.PUT_LINE('Subject Marks : '); DBMS_OUTPUT.PUT_LINE('Physics : ' || Physics); DBMS_OUTPUT.PUT_LINE('Chemistry : ' || Chemistry); DBMS_OUTPUT.PUT_LINE('Maths : ' || Maths); DBMS_OUTPUT.PUT_LINE('Biology : ' || Biology); DBMS_OUTPUT.PUT_LINE('Total Marks : ' || Total || '/400'); DBMS_OUTPUT.PUT_LINE('Percentage : ' || Percentage || '%'); END; /