PL SQL Stored Procedures with examples || PL/SQL Tutorial for Beginners in Hindi

[@CodingGlitz]

Thanks for watching. If you want to connect on LinkedIn and stay updated with my professional updates and network with me, here's my LinkedIn profile: LinkedIn: www.linkedin.com/in/biplabparida

[@itsdragonav]

Actually i want to learn ETL, so please suggest me best video lectures that i can understood easily.

[@prashantp9029]

I was eagerly waiting for the same

[@bhuv16]

Great Work..Please continue with your whole video series

[@CodingGlitz]

Sure.. Thanks😃

[@manishagupta5307]

Big fan of urs sir.Its very useful for me as s beginner.

[@CodingGlitz]

Thanks 👍

[@aaryanb4real]

i started watching your videos before my exam and really sir you teach very well all concepts clear🙏🏽

[@CodingGlitz]

Glad to hear that

[@atharvajadhav2972]

Sir your teaching is so amazing

[@bhanuchaurasia6335]

Nice lecture Aj Procedure Concept clear hua .....

[@CodingGlitz]

Thanks🙂

[@kanikasuneja7777]

22:16 vhi pe, kha pe? pls be clear... Agr OUT nhi mention krte to kya hoga?

[@NTR_manavadu]

why do we need z int here while executting the proc... we cant directly execute it without declaring?

[@randomtubebangla4867]

Crystal clear brother

[@atishkumarbarik1375]

Hi sir, Plz guide us on realtime scenario 🙏

[@vamshikrishna9204]

Sir every time why you are selecting the code and executing it Why are you writing two times begin and end is that correct way at 20:05

[@CodingGlitz]

Regarding selecting code: That has been my practice for years. To debug a smaller part of the query it helps. And I am not able to see where I have used 2 begins.

[@vamshikrishna9204]

@@CodingGlitz At 20:44 already you declared begin .In that section you have written v_z:=v_z*v_z Then again for passing values again you written begin

[@CodingGlitz]

I think you are confused. Actually there are 2 parts. 1st part is till the 1st end; before declare, which is the stored procedure. 2nd part starts from DECLARE till the 2nd end. Which is used for executing the procedure. This is explained at 17:13 Please increase the speed to 1.5x or 2x but don't skip otherwise you will face such issues.

[@vamshikrishna9204]

@@CodingGlitz ok sir now I understood sir can please provide notes in comment box Thank you for replying sir

[@CodingGlitz]

Don't have notes. Will try to prepare and share.

[@hrishi2839]

I m facing issue while executing the procedure, output dont come

[@hrishi2839]

Ok issue is fixed, repeating playlist again...

[@nomadickeshav4760]

Hi bro great efforts can u please help me to connect oracle sql dev to oracle db facing issue since more than 15 days..showing some errors

[@pawanpetkar5670]

Great work ...please make video on binary integer using in procedure

[@mainlykanchan8740]

Thanks for video 🙏🏼

[@vijayarana2087]

For the last two examples OUT and Inout is is mandatory to call the procedure from declare section? can we use execute?

[@MUSTAQIM_BAGWAN]

Forward declaration in procedure explain kre plz

[@gauravgupta-rc8uq]

how can write in sql server for finding maximum between two no

[@prakashmore1108]

sir you wroye is instead of as is it allowed ?

[@CodingGlitz]

Sorry didn't get you

[@ll_ashu_ll]

Sir in case of in parameter or out parameter can v take input from user for value Like when we create normal program of plsql that time we can declare V_name := '&enter_name' When we execute query that it will ask to enter name from to user

[@CodingGlitz]

Yes that is the use of parameters, to take input from user

[@viveksing1292]

Procedure for the Nth min salary create or replace procedure min_salary(n number ,v_salary out number) as begin select min(salary) into v_salary from (select salary from employee_info order by salary desc fetch first n rows only); end; excution of procedure: declare n number:=4; s_salary number; begin min_salary(n,s_salary); dbms_output.put_line(s_salary); end;

[@ArbindKumar-fw8xw]

Super 👌

[@dineshkumarachari8757]

i'm create simple select statement stored procedure in oracle sql developer tool is not create. what will do? any access required?i;m already give stored procedure access on user any other else?

[@CodingGlitz]

You should be able to create. Just verify again if you have Create grant for your user.

[@tarunsuthar7427]

Isn't IN for pass by value and OUT for pass by reference??

[@MundheNitin]

hi sir ,how to find nth highet salary using store procedure

[@CodingGlitz]

Nth highest salary can be found using simple queries no need to use stored procedures. But if you want to use stored procedure then you can take N as parameter and use it in your query. For Nth highest salary query using 3 different solution pls refer: kzbin.info/www/bejne/oqHLpaR8j5Kch8U

[@MUSTAQIM_BAGWAN]

Kl paper he or aaj tum ye video dekh rho ho hmm.😅

[@diraneserges6076]

Thanks very much

[@pranishsonone7839]

bhai aap task solve karne me help Karo na or clear vese mene Kiya he bu error bata raha he

[@Vinod_DeshBhakat]

Sir it show error 😢😢

[@VaishnaviMondhe]

HI SIR ........ CAN YOU PLEASE EXPLAIN IT AGAIN...PLEASE

[@prashantp9029]

Hi, please share some more example

[@himanshuarora1910]

still i didnt get whats the need for procedure we could have do it without procedure 🤯

[@nitinmahajan2868]

💫💫💫

[@saaii9]

Error ara he bhai live sql me karetho

[@viveksing1292]

Kindly check the procedure create or replace procedure min_salary(n number) is begin select min(salary) from (select salary from employee_info order by salary desc fetch first n rows only); end;

[@nd8223]

Tho Chhhaliye Shuru karthe Hai

[@gauravgupta-rc8uq]

create procedure NTHhighsalary @n int as begin select e1.salary ,count( distinct e2.SALARY) from EMPLOYEE e1 join EMPLOYEE e2 on e1.SALARY

[@miclevarghese5869]

CREATE OR REPLACE PROCEDURE myNTH(nthsal INT) IS num1 employee.salary%type; num2 number; BEGIN SELECT e1.salary, count(distinct e2.Salary) into num1,num2 from EMPLOYEE E1 JOIN EMPLOYEE E2 ON E1.Salary