PROCEDURES IN PL/SQL WITH EXAMPLES || PL/SQL TUTORIAL

[@mohitagrawal1555]

your way of explaining concept is amazing !!

[@mohitdodiya3989]

Thanks ma'am ,❤️Wonderful explanation and understandable .it's very important and useful for me.👍

[@zeenathkhatoon7701]

Could you plz write one sample procedure with one input parameter and one output parameter,that output parameter needs to return multiple values. FOR EXAMPLE: if we pass input parameter as employee designation(like developer) then it has to return all the employee id"s those who are working under that particular designation. plz make one more video with this concept,it will help all

[@amazonking828]

lovely voice.Great combination of melodious voice and intelligence.

[@rohitkumar-bf9xe]

This is probably the best explained lesson on this topic i have seen but you should have to show practical also...

[@IniyadharshiniGomadurai]

your concepts are very clear ,it is easy to understand. can you pls increase your volume.

[@lovelydaya5038]

Your explanation is very good and your voice is just awesome

[@jaishreekrishna7511]

The video was simple and to the point.. Thank you very much

[@vishalbhola07]

While defining the procedure in 1st example why haven't we write create or replace procedure name instead of it normally procedure keyword is written.

[@chittardhar8861]

you got any answers man??

[@samratpatel8060]

In PL/SQL, there are different ways to create a procedure. The syntax you used earlier, starting with `PROCEDURE findmul(...) IS`, is one way. However, if you're creating the procedure separately, you can indeed use the `CREATE PROCEDURE` syntax. Here's an alternative version of your code using the `CREATE PROCEDURE` approach: ```plsql CREATE OR REPLACE PROCEDURE findmul( x IN NUMBER, y IN NUMBER, z OUT NUMBER ) AS BEGIN z := x * y; END findmul; / DECLARE a NUMBER; b NUMBER; c NUMBER; BEGIN a := 50; b := 10; findmul(a, b, c); DBMS_OUTPUT.PUT_LINE('Multiplication is ' || c); END; / ``` In this version, the `CREATE OR REPLACE PROCEDURE` statement is used to define the procedure separately from the anonymous PL/SQL block. The `DECLARE` section then declares variables and the `BEGIN` section contains the executable part of your code. The choice between creating the procedure within the anonymous block (`PROCEDURE findmul(...) IS ... BEGIN ... END;`) or separately (`CREATE PROCEDURE findmul(...) AS ...`) depends on your specific requirements and coding style preferences. Both approaches are valid in PL/SQL.

[@MalayRawwrr]

@@samratpatel8060 great answer!

[@sakshishikhare2376]

Thank you so much ! It was very help ful for my exam

[@umangsharma1742]

Nicely explained. Got the whole concept.

[@jamesfernandes4044]

Explainedwith perfection 👍.. Keep up the work

[@r.vignesh1431]

Thank u mam .....it was so helpful for my practical xam.. ❤

[@prathamesh0195]

Excellent mam i can understand very good

[@nishanksoni502]

Thanks for the video i was looking for this topic in an easy way. :)

[@waqaskhan2165]

Voice is just owesome

[@nimishpandey2693]

padhai krle bhai avaaz pe mat dhyaan de

[@waqaskhan2165]

@@nimishpandey2693 parhai krli bhai ab job krrha hun

[@chaitanyadamarla05]

Good morning have a nice day... Thank you a lot

[@middleofficechitose4866]

Wow, your tutorial is amazing, with simple presentation in a paper tou can make me understand how function and procedures in oracle. Thank you. Please make vid tutorial iseries n implementing this plnsql in orqcle apex, I'm sure your follower will grow more....cmiww

[@sahilkr28]

Awesome Explanation !❤

[@bodlashivaprasad9505]

Inside the 1st begin and end block we can perform the operation for abc or not. If your answer is yes. Then why you have taken another begin /end block. If your answer is no. Why we can not perform .?

[@naveenpab220]

Voice is good and explanation alsi

[@suchitrat5888]

Thank you so much 🥰 madam

[@sumitghosh5025]

Thanks mam .....got my topic cleared

[@naturesboy7482]

Ya it is really helpful

[@danhassler6585]

Very good

[@Ganeshay-996]

Superb job

[@MdAfzal-mj1mu]

Thnx for this amazing video ..

[@samratpatel8060]

3:23 isnt CREATE PROCEDURE findmul() should be written?

[@joaovinicius4838]

Thanks from BRASIL SIL SIL SIL🤙

[@rjiv7778]

Best video i found

[@sindhuc7359]

Thank you so much mam! Very helpful

[@alwin804]

Really helpful ...........

[@yashrajtechnicals9456]

Nice explanation it helped ma aaaaa looot 🔥

[@mafikulislam3469]

Your videos on pl/sql are really helpful. Waiting for more videos. Please suggest me a book on pl/sql.

[@30dhanush]

Can you upload bulk collect concepts and collections and nested if.

[@ishangarg5498]

very nicely explained

[@mahendranp6715]

Nice explanation

[@elitexmedia2899]

when to use 'call' and when to use 'exec' for calling the stored procedure?

[@mahdinouira3261]

cab u explain the named notation procedure

[@thisisvimala9999]

Can we call procedure inside the function??

[@kalaipriya4831]

i have doubt that procedures have parameter modes that u Taught IN,OUT,INOUT...For functions also as same

[@shaikhrahil5621]

What's the difference between is/as didn't understand that other than I got it😅

[@sonughatte3693]

Why did you stop creating videos like this ma'am

[@crackconcepts]

I still do. Check out the latest videos

[@mmanigandan2474]

Hi mam. can you example the package

[@shivpatil390]

the procdure will be same for cube of a number right ? we just have to put x= x*x*x?

[@amazonking828]

yes

[@LALITJANGID-j6z]

👌👌👌👌👌👌👌

[@pravingurav7041]

Mam any app for run plsql code on mobile

[@sunnybasu5920]

can anyone kindly tell me why create/replace keyword was not used inside the pl/sql for creating the procedure? thanks in advance

[@chittardhar8861]

tell me too , if you got to know

[@harshavardhanreddy523]

Thankyou so much

[@ejpeninger]

Thank you this was very helpful. In Oracle once you have created the procedure, can you later view and edit your code? This is not possible in MS SQL.

[@manikantabathula9037]

thanks mam..

[@take_the_trade]

What is diff btwn IS and AS?

[@thatoramphore6709]

They are the same. Most people prefer IS

[@mohammedmuzammil2767]

Thankyou mam

[@anirudhsharma5526]

Can we perform all arithmetic operations in one single procedure ?

[@sauskeuchiha6749]

thank_kuu :)

[@saurabhsinha8913]

okk