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

[@rohitkumar-bf9xe]

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

[@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.

[@amazonking828]

lovely voice.Great combination of melodious voice and intelligence.

[@nishanksoni502]

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

[@jaishreekrishna7511]

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

[@IniyadharshiniGomadurai]

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

[@r.vignesh1431]

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

[@sakshishikhare2376]

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

[@naturesboy7482]

Ya it is really helpful

[@lovelydaya5038]

Your explanation is very good and your voice is just awesome

[@jamesfernandes4044]

Explainedwith perfection 👍.. Keep up the work

[@umangsharma1742]

Nicely explained. Got the whole concept.

[@suchitrat5888]

Thank you so much 🥰 madam

[@waqaskhan2165]

Voice is just owesome

[@nimishpandey2693]

padhai krle bhai avaaz pe mat dhyaan de

[@waqaskhan2165]

@@nimishpandey2693 parhai krli bhai ab job krrha hun

[@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

[@prathamesh0195]

Excellent mam
i can understand very good

[@chaitanyadamarla05]

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

[@30dhanush]

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

[@alwin804]

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

[@Ganeshay-996]

Superb job

[@sahilkr28]

Awesome Explanation !❤

[@danhassler6585]

Very good

[@MdAfzal-mj1mu]

Thnx for this amazing video ..

[@sumitghosh5025]

Thanks mam .....got my topic cleared

[@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 .?

[@naveenpabba220]

Voice is good and explanation alsi

[@rjiv7778]

Best video i found

[@joaovinicius4838]

Thanks from BRASIL SIL SIL SIL🤙

[@elitexmedia2899]

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

[@sindhuc7359]

Thank you so much mam! Very helpful

[@mafikulislam3469]

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

[@ishangarg5498]

very nicely explained

[@harshavardhanreddy523]

Thankyou so much

[@kalaipriya4831]

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

[@mahdinouira3261]

cab u explain the named notation procedure

[@mahendranp6715]

Nice explanation

[@samratpatel8060]

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

[@mohammedmuzammil2767]

Thankyou mam

[@yashrajtechnicals9456]

Nice explanation it helped ma aaaaa looot 🔥

[@thisisvimala9999]

Can we call procedure inside the function??

[@LALITJANGID-j6z]

👌👌👌👌👌👌👌

[@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..

[@shaikhrahil5621]

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

[@mmanigandan2474]

Hi mam. can you example the package

[@sonughatte3693]

Why did you stop creating videos like this ma'am

[@crackconcepts]

I still do. Check out the latest videos

[@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

[@pravingurav7041]

Mam any app for run plsql code on mobile

[@shivpatil390]

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

[@amazonking828]

yes

[@saurabhsinha8913]

okk

[@sauskeuchiha6749]

thank_kuu :)

[@take_the_trade]

What is diff btwn IS and AS?

[@thatoramphore6709]

They are the same. Most people prefer IS

[@anirudhsharma5526]

Can we perform all arithmetic operations in one single procedure ?