@@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?
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.
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.
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
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.
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; /
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; /
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%'
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; /
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
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; /
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
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
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
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; /
🎯 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
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; /
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
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
my college lecturer was completely useless, I almost failed my mid exams, dropped the class, this lecturer is so much nicer thanks
college name
Yeah mee too
Me toooo
Bhai hmare yha to aadhe sem lecturer hire hi ni Kiya gya tha..😂🤦
God bless you sir. Can't believe you covered all important topics in 30 minutes only.
I am glad it was useful.
Seriously that was what we needed.
A short time basic understanding of syntax, flow,etc
Thanks barter
@@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?
best abstract of PL/SQL in 30 mts. Helped me a lot. Thankyou.
Most welcome!
well, I haven't gone through other content of this creator but this single video won my subscription. Thank you BBarters.
This is a great tutorial!
Props from Quebec, Canada!
Good refresher in 30 minutes. Thanks for putting this together.
Covered my complete PL/SQL syllabus in 30 mins!
i find all i need in this video about pl sql ,thank you so much
Wonder ful explaination..! well done Barters..Appreciated your job❣❣❣❣
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.
Your explanation is best among all available videos on RUclips. Great work keep it up. Subscribed and liked..
Concise and optimized tutorial. All topics covered in short with necessary points. :)
Best explanation of PL/SQL in 30 mts. Amazing. Keep it up man...!!! THankyou
U re a time-saver, a whole module in 30min, u did great job thank u
Glad it helped
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.
Good content for brush up if you are already aware of these concepts. Thanks for sharing.
Crystal clear explanation,covered each important corner.Thank you .
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
Great to hear! Glad to be of help!
Nicely explained. Covered all major topics of plsql course. Thanks
Quick and to the point explained.
Good job.
Having my exams tomorrow and this helped me soo much,Thank Youu sir
Sir Thank You so much you're a savior for me.
basics of pl/sql has been explained very well.
Thanks a lot
Very informative for beginners, appreciate the efforts
thank you so much, my lecturer, is completely incompitent
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.
Nice and concise video tutorials for beginners and clearly explained the topics with demo.
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;
/
great overview of PL SQL. Thanks.
man, you saved the day :)
Thank you for this video. It's been extremely helpful!!
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;
/
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%'
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;
/
Great video man ...just the right information i needed 👏
Nice video..Short n simple👍
Very useful tutorial. Thank you very much!
Hoping this gets me through my exam later today😂😅
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
Hi
can Please how to pass list as a i/p variable in stored procs
This is rich and very concise. I just wish the code was properly formatted.
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;
/
thanks a lot sir,useful video which clear my doubt
Thank you very much sir for this awesome video. All my doubts are now cleared.
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
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?
you need to download oracle brother.
look for oracle application express (apex)
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.
How to install Oracle database expression edition
can anyone give me the tables for the above query?
Does any one have above PPT? I want to download it
sir what does New.email does?? basicaly i have never user new?
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
very nice and concise video on PL/SQL
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
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;
/
Why do we increment after dbms.putline and not before?
Great video sir. Very helpful 🙌
🎯 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
dogshit ai
Great Video and Very Insightful
Very Very nice and informative
Glad that it was helpful to you.
How to write the query to (select name who is getting maximum annual salry )...if i know only monthly salary.
SELECT NAME FROM TABLE1 WHERE SALARY = (SELECT MAX(SALAR) FROM TABLE1)
Any one having this pdf please send with me urgently
Thank you sir. you have explained very well.
Bro nen civil 2014 passed out, present nen software side velladaniki veeluntunda, unte am cheyyalo avaraina cheppagalara plz....
Where can I get lots of practice exercises for PL/SQL
Very good explanation..thumbs up
Which software did you use sir??
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;
/
This is very good for new learner
Q4. Write a PL/SQL code Loop Exit query.(WHILE LOOP)
CODE:-
DECLARE
a number(2):=1;
begin
while a
Thankyou so much sir thankyou so much life saver!!!
I want this ppt can you please provide it if possible.Thank you for clearing concept clearly.
Please revert me
Good tutorial for the brush up
thank you , saved me :)
very nice explanation sir... helped me a lot....
Can we modify the second example of explicit cursors to display top 2 earners in each department? Kindly reply.
Really nice Tutorial..Thank you so much
Glad it was helpful!
Very helpful video... thank you sir...
great lecture , save a lot of time
These topics are enough na?
Ppt is not opening . It's asking for permission.
Great tutorial, Thank you sir.
Please make same tutorial, but using the HR scheme 🙏.
where shall i type this program? which tool is this? please help
console oracle db.
SQL developer or SQL *plus
Thank you so much Sir!
Most welcome!
really fantastic class.
very useful for beginners,Thanq
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
Hola Nikhat, will be uploading more videos (programming specially) on this channel soon. Please subscribe for the same.
helloo, did u working in oracle till now , how can be advance in oracle give suggestion ....
Nikhat Saba Hi..if u get more videos plz share wid me....
Email IDs are awesome 😂😆 n thanks nice video 🖖😁
Hello Sir,
I want to learn pl/sql programming. Could u please tell me how can I contact you for the same?
bbarter you did great job.
thank you I learned a lot
Thank you so much sir :)
HI, CAN YOU PLZ MAKE MORE THESE KIND OF VIDEOES ON REMAINING TOPICS OF PL/SQL
heyy!! can you plz tell me..
this video is 7 yr ago. so does it covers all the concepts? will it be fine to follow it in todays date?
Yes, for basic understanding basic topics are clearly explained
And it is fine to follow nowadays because these are basic every apex version topics
thank u it was so helpful to me
found really helpful. Thank you.
Very well explained
great work. thanks much
Sir what's d difference between procedure n function plzz answer!
procedure- may or may not return a value. A function ALWAYS returns a value.
Excellent tutorial