@@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.
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
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 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%'
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; /
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; /
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
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
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!
This is a great tutorial!
Props from Quebec, Canada!
well, I haven't gone through other content of this creator but this single video won my subscription. Thank you BBarters.
Good refresher in 30 minutes. Thanks for putting this together.
Concise and optimized tutorial. All topics covered in short with necessary points. :)
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 find all i need in this video about pl sql ,thank you so much
Your explanation is best among all available videos on RUclips. Great work keep it up. Subscribed and liked..
U re a time-saver, a whole module in 30min, u did great job thank u
Glad it helped
Wonder ful explaination..! well done Barters..Appreciated your job❣❣❣❣
Covered my complete PL/SQL syllabus in 30 mins!
Best explanation of PL/SQL in 30 mts. Amazing. Keep it up man...!!! THankyou
Good content for brush up if you are already aware of these concepts. Thanks for sharing.
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.
Crystal clear explanation,covered each important corner.Thank you .
Sir Thank You so much you're a savior for me.
Quick and to the point explained.
Good 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
Great to hear! Glad to be of help!
thankyou so much for saving me from exams! you are great
Very informative for beginners, appreciate the efforts
Nicely explained. Covered all major topics of plsql course. Thanks
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.
great overview of PL SQL. Thanks.
basics of pl/sql has been explained very well.
Thanks a lot
Great video man ...just the right information i needed 👏
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.
Thank you for this video. It's been extremely helpful!!
Having my exams tomorrow and this helped me soo much,Thank Youu sir
Nice and concise video tutorials for beginners and clearly explained the topics with demo.
Very useful tutorial. Thank you very much!
man, you saved the day :)
Nice video..Short n simple👍
This is rich and very concise. I just wish the code was properly formatted.
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
Great Video and Very Insightful
Great video sir. Very helpful 🙌
Thank you sir. you have explained very well.
Thankyou so much sir thankyou so much life saver!!!
thanks a lot sir,useful video which clear my doubt
Thank you so much Sir!
Most welcome!
Very Very nice and informative
Glad that it was helpful to you.
Hoping this gets me through my exam later today😂😅
Great tutorial, Thank you sir.
thank you , saved me :)
very nice and concise video on PL/SQL
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 lecture , save a lot of time
I love you, thank you so much
Thank you so much sir :)
found really helpful. Thank you.
thank you I learned a lot
This is very good for new learner
great work. thanks much
Very good explanation..thumbs up
Really nice Tutorial..Thank you so much
Glad it was helpful!
Good tutorial for the brush up
thank u it was so helpful to me
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%'
Thank you very much sir for this awesome video. All my doubts are now cleared.
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;
/
Very helpful video... thank you sir...
really fantastic class.
Hi
can Please how to pass list as a i/p variable in stored procs
Helped a lot 😁❤
Please make same tutorial, but using the HR scheme 🙏.
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;
/
How to install Oracle database expression edition
very useful for beginners,Thanq
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
These topics are enough na?
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)
Which software did you use sir??
I want this ppt can you please provide it if possible.Thank you for clearing concept clearly.
Please revert me
u r a hero👍👍👍
very nice explanation sir... helped me a lot....
Any one having this pdf please send with me urgently
Where can I get lots of practice exercises for PL/SQL
can anyone give me the tables for the above query?
bbarter you did great job.
sir what does New.email does?? basicaly i have never user new?
Does any one have above PPT? I want to download it
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....
Why do we increment after dbms.putline and not before?
Email IDs are awesome 😂😆 n thanks nice video 🖖😁
Can we modify the second example of explicit cursors to display top 2 earners in each department? Kindly reply.
Very well explained
Bro nen civil 2014 passed out, present nen software side velladaniki veeluntunda, unte am cheyyalo avaraina cheppagalara plz....
Ppt is not opening . It's asking for permission.
Thanks a lot.. Its very much helpful
Excellent tutorial
Thank you!
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
Good video ... very helpful
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)
Very good video sir
Hello Sir,
I want to learn pl/sql programming. Could u please tell me how can I contact you for the same?
Thank you