Thanks ma'am ,❤️Wonderful explanation and understandable .it's very important and useful for me.👍
@zeenathkhatoon7701
3 жыл бұрын
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
@vishalbhola07
4 жыл бұрын
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
8 ай бұрын
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.
@rohitkumar-bf9xe
3 жыл бұрын
This is probably the best explained lesson on this topic i have seen but you should have to show practical also...
@IniyadharshiniGomadurai
2 ай бұрын
your concepts are very clear ,it is easy to understand. can you pls increase your volume.
@r.vignesh1431
3 жыл бұрын
Thank u mam .....it was so helpful for my practical xam.. ❤
@sakshishikhare2376
3 жыл бұрын
Thank you so much ! It was very help ful for my exam
@nishanksoni502
4 жыл бұрын
Thanks for the video i was looking for this topic in an easy way. :)
@suchitrat5888
Жыл бұрын
Thank you so much 🥰 madam
@naturesboy7482
4 жыл бұрын
Ya it is really helpful
@amazonking828
3 жыл бұрын
lovely voice.Great combination of melodious voice and intelligence.
@danhassler6585
Жыл бұрын
Very good
@jamesfernandes4044
3 жыл бұрын
Explainedwith perfection 👍.. Keep up the work
@umangsharma1742
4 жыл бұрын
Nicely explained. Got the whole concept.
@jaishreekrishna7511
Жыл бұрын
The video was simple and to the point.. Thank you very much
@prathamesh0195
Жыл бұрын
Excellent mam i can understand very good
@30dhanush
4 жыл бұрын
Can you upload bulk collect concepts and collections and nested if.
@lovelydaya5038
3 жыл бұрын
Your explanation is very good and your voice is just awesome
@alwin804
4 жыл бұрын
Really helpful ...........
@Ganeshay-996
4 жыл бұрын
Superb job
@waqaskhan2165
3 жыл бұрын
Voice is just owesome
@nimishpandey2693
Жыл бұрын
padhai krle bhai avaaz pe mat dhyaan de
@waqaskhan2165
Жыл бұрын
@@nimishpandey2693 parhai krli bhai ab job krrha hun
@joaovinicius4838
5 ай бұрын
Thanks from BRASIL SIL SIL SIL🤙
@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 .?
@sahilkr28
Жыл бұрын
Awesome Explanation !❤
@naveenpabba220
2 жыл бұрын
Voice is good and explanation alsi
@MdAfzal-mj1mu
3 жыл бұрын
Thnx for this amazing video ..
@chaitanyadamarla05
3 жыл бұрын
Good morning have a nice day... Thank you a lot
@middleofficechitose4866
3 жыл бұрын
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
@sumitghosh5025
2 жыл бұрын
Thanks mam .....got my topic cleared
@rjiv7778
Жыл бұрын
Best video i found
@ishangarg5498
Жыл бұрын
very nicely explained
@yashrajtechnicals9456
3 жыл бұрын
Nice explanation it helped ma aaaaa looot 🔥
@samratpatel8060
8 ай бұрын
3:23 isnt CREATE PROCEDURE findmul() should be written?
@elitexmedia2899
2 жыл бұрын
when to use 'call' and when to use 'exec' for calling the stored procedure?
@mahendranp6715
2 жыл бұрын
Nice explanation
@shaikhrahil5621
Жыл бұрын
What's the difference between is/as didn't understand that other than I got it😅
@thisisvimala9999
2 жыл бұрын
Can we call procedure inside the function??
@sindhuc7359
4 жыл бұрын
Thank you so much mam! Very helpful
@kalaipriya4831
3 жыл бұрын
i have doubt that procedures have parameter modes that u Taught IN,OUT,INOUT...For functions also as same
@mafikulislam3469
4 жыл бұрын
Your videos on pl/sql are really helpful. Waiting for more videos. Please suggest me a book on pl/sql.
@mahdinouira3261
Жыл бұрын
cab u explain the named notation procedure
@harshavardhanreddy523
Жыл бұрын
Thankyou so much
@mohammedmuzammil2767
Жыл бұрын
Thankyou mam
@manikantabathula9037
2 жыл бұрын
thanks mam..
@sunnybasu5920
2 жыл бұрын
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
@mmanigandan2474
Жыл бұрын
Hi mam. can you example the package
@ejpeninger
3 жыл бұрын
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.
@pravingurav7041
3 жыл бұрын
Mam any app for run plsql code on mobile
@shivpatil390
3 жыл бұрын
the procdure will be same for cube of a number right ? we just have to put x= x*x*x?
@amazonking828
3 жыл бұрын
yes
@user-rp3rl4qu1g
2 жыл бұрын
👌👌👌👌👌👌👌
@sauskeuchiha6749
Жыл бұрын
thank_kuu :)
@sonughatte3693
5 ай бұрын
Why did you stop creating videos like this ma'am
@crackconcepts
5 ай бұрын
I still do. Check out the latest videos
@anirudhsharma5526
2 жыл бұрын
Can we perform all arithmetic operations in one single procedure ?
Пікірлер: 65