@@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
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%'
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
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
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.
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.
This is a great tutorial!
Props from Quebec, Canada!
Your explanation is best among all available videos on CZcams. Great work keep it up. Subscribed and liked..
Concise and optimized tutorial. All topics covered in short with necessary points. :)
Good content for brush up if you are already aware of these concepts. Thanks for sharing.
Best explanation of PL/SQL in 30 mts. Amazing. Keep it up man...!!! THankyou
Covered my complete PL/SQL syllabus in 30 mins!
U re a time-saver, a whole module in 30min, u did great job thank u
Glad it helped
Crystal clear explanation,covered each important corner.Thank you .
Wonder ful explaination..! well done Barters..Appreciated your job❣❣❣❣
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.
Nicely explained. Covered all major topics of plsql course. Thanks
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!
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%'
Quick and to the point explained.
Good job.
Having my exams tomorrow and this helped me soo much,Thank Youu sir
basics of pl/sql has been explained very well.
Thanks a lot
Sir Thank You so much you're a savior for me.
Nice and concise video tutorials for beginners and clearly explained the topics with demo.
thank you so much, my lecturer, is completely incompitent
great overview of PL SQL. Thanks.
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.
Very informative for beginners, appreciate the efforts
Thank you for this video. It's been extremely helpful!!
This is rich and very concise. I just wish the code was properly formatted.
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.
Very useful tutorial. Thank you very much!
Hoping this gets me through my exam later today😂😅
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
thanks a lot sir,useful video which clear my doubt
man, you saved the day :)
Nice video..Short n simple👍
Thank you! Wonderful video 😊
Glad you enjoyed it!
Great video man ...just the right information i needed 👏
Thank you sir. you have explained very well.
great lecture , save a lot of time
very nice and concise video on PL/SQL
Any one having this pdf please send with me urgently
Thank you very much sir for this awesome video. All my doubts are now cleared.
Very Very nice and informative
Glad that it was helpful to you.
Great Video and Very Insightful
Very good explanation..thumbs up
Great video sir. Very helpful 🙌
Good tutorial for the brush up
Thankyou so much sir thankyou so much life saver!!!
This is very good for new learner
Really nice Tutorial..Thank you so much
Glad it was helpful!
Very well explained
great work. thanks much
thank you , saved me :)
Great tutorial, Thank you sir.
Thank you so much Sir!
Most welcome!
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 useful for beginners,Thanq
Please make same tutorial, but using the HR scheme 🙏.
thank you I learned a lot
Very helpful video... thank you sir...
Thank you so much sir :)
really fantastic class.
very nice explanation sir... helped me a lot....
thank u it was so helpful to me
I love you, thank you so much
Email IDs are awesome 😂😆 n thanks nice video 🖖😁
Excellent
Nice Tutorial
Excellent tutorial
bbarter you did great job.
this video was Pog
Just explain each one a bit more
Just Awesome
Thank you deer
Thanks you sir....
Thank you
Very good video sir
Thanks a lot.. Its very much helpful
Which software did you use sir??
Good video ... very helpful
Thanq so much :)
Awesome video.
Hi
can Please how to pass list as a i/p variable in stored procs
Helped a lot 😁❤
grazie mille!
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 video!
Why do we increment after dbms.putline and not before?
amazing tutorial
u r a hero👍👍👍
Good Explanation
Can we modify the second example of explicit cursors to display top 2 earners in each department? Kindly reply.
Thank you!!
can anyone give me the tables for the above query?
Amazing
beginners cannot understand.. should have made it simple
great video :)
i just wanna rock -lil uzi vert
sir what does New.email does?? basicaly i have never user new?