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
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.
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 .?
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
your way of explaining concept is amazing !!
Thanks ma'am ,❤️Wonderful explanation and understandable .it's very important and useful for me.👍
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
This is probably the best explained lesson on this topic i have seen but you should have to show practical also...
your concepts are very clear ,it is easy to understand. can you pls increase your volume.
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.
you got any answers man??
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.
Your explanation is very good and your voice is just awesome
lovely voice.Great combination of melodious voice and intelligence.
The video was simple and to the point.. Thank you very much
Explainedwith perfection 👍.. Keep up the work
Thank u mam .....it was so helpful for my practical xam.. ❤
Nicely explained. Got the whole concept.
Thanks for the video i was looking for this topic in an easy way. :)
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 .?
Voice is just owesome
padhai krle bhai avaaz pe mat dhyaan de
@@nimishpandey2693 parhai krli bhai ab job krrha hun
Thank you so much ! It was very help ful for my exam
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
Excellent mam
i can understand very good
Can you upload bulk collect concepts and collections and nested if.
Good morning have a nice day... Thank you a lot
Voice is good and explanation alsi
Very good
Ya it is really helpful
Awesome Explanation !❤
cab u explain the named notation procedure
Your videos on pl/sql are really helpful.
Waiting for more videos.
Please suggest me a book on pl/sql.
i have doubt that procedures have parameter modes that u Taught IN,OUT,INOUT...For functions also as same
Superb job
Thank you so much 🥰 madam
when to use 'call' and when to use 'exec' for calling the stored procedure?
Thanks mam .....got my topic cleared
Thnx for this amazing video ..
Really helpful ...........
Best video i found
Can we call procedure inside the function??
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.
What's the difference between is/as didn't understand that other than I got it😅
3:23 isnt CREATE PROCEDURE findmul() should be written?
Thanks from BRASIL SIL SIL SIL🤙
very nicely explained
Hi mam. can you example the package
Nice explanation it helped ma aaaaa looot 🔥
Nice explanation
Thank you so much mam! Very helpful
the procdure will be same for cube of a number right ? we just have to put x= x*x*x?
yes
Mam any app for run plsql code on mobile
can anyone kindly tell me why create/replace keyword was not used inside the pl/sql for creating the procedure? thanks in advance
tell me too , if you got to know
👌👌👌👌👌👌👌
Thankyou mam
Thankyou so much
Why did you stop creating videos like this ma'am
I still do. Check out the latest videos
thanks mam..
Can we perform all arithmetic operations in one single procedure ?
What is diff btwn IS and AS?
They are the same. Most people prefer IS
okk
thank_kuu :)