HomeОбразованиеRelated VideosMore From: Manish Sharma

PL/SQL tutorial 28: Cursor Parameter In Oracle Database By Manish Sharma

387 ratings | 39074 views
Learn How To Create Parameterized cursor in Oracle Database with easy to understand example by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-parameter Previous Tutorial ► Create Explicit Cursor: https://youtu.be/3q7dW_d2KVc ►Cursors : https://youtu.be/_snAMqCBitg ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (21)
Balamurali Chandran (6 months ago)
Add these courses in Udemy. It would be great.
Aliagha Aghayev (11 months ago)
Dear Manis Sharma There is cursor parameter is varchar datatype but open cursor parameter is number "open p_cur_rebelli(105)". How can this work ? I did it but happened error By The way Thank you very much this great helpful video channel Good Luck
TRY It (3 months ago)
Aliagha Aghayev same doubt
thangaraj mtr (1 year ago)
can you help me to understand cursor parameter with two or three arguments inside???
anchal therkar (1 year ago)
sir var_e_I'd me aapne varchar2 q liya hai instead of number datatype...plss do reply
Anvay Joshi (1 year ago)
Hi Manish,pls tell me what will be the value of employee_id in the where clause in the declare part of the block????
SIRIGIRI HARI KRISHNA (1 year ago)
THANK YOU SO MUCH MANISH YOUR VIDEO ARE USEfuL AND CAN U EXPLAIN THEORY PART WITH EXAMPLES WE CAN MAKE MORE UNDERSTANDING HERE I HAVE DOUBT HERE PARAMETER VAR_E_ID VARCHAR2 AND Employee_ID<VAR_E_ID IS THE CONDITION WHERE EMPLOYEE_ID IS NUMBER DATA TYPE AND IN OPEN CURSOR WE ARE PASSING NUMBER DATATYPE,' MY QUESTION IS WHY U GIVEN VAR_E_ID IS VARCHAR2 ? if all other places we used number data type and number value;
thangaraj mtr (1 year ago)
we can store both number and string in varchar2 datatype
Vishal Suryavanshi (1 year ago)
A knowledge of subject, quality of voice, and presentation skills... Manish Sir, You are a complete package. Really great work. Thank you so much from me and all your online students.
sheelu singhal (1 year ago)
there is one problem ..after executing the code the last name is repeated two times...why??
suraj navathe (2 months ago)
out put statement should write after exit
Raj Mestri (1 year ago)
u have to close the command prompt and restart again.
Vikram Singh Rathore (2 years ago)
very nice thanks
santosh chary (2 years ago)
Good Tutorial...really helpful :)...thanks!
Manish Sharma (2 years ago)
Thank you so much for your appreciation. It means a lot to me.
Ayoob manker (2 years ago)
you are best....thanks Manish...
Manish Sharma (2 years ago)
+Ayoob manker You are most welcome. It is always a pleasure to help.
Bibhuti Bhusan Panda (2 years ago)
How many tutorials yet to go?? It's a very urgent requirement of me
maryam ouhami (2 years ago)
Hello Manish can you please explain how to create a type objet for eample TYPE TABLE IS table_last_name VARCHAR2(35)
Saidmamad Gulomshoev (2 years ago)
Thank you so much, Manesh sir, for your tutorials!!! Your video tutorials are the best!
Manish Sharma (2 years ago)
+Saidmamad Gulomshoev Thanks a lot. It is always a pleasure to be appreciated. Please Keep watching and do make sure to LIKE and SHARE.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.