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

preview_player
Показать описание
PLSQL stored procedure.

How to create, execute and drop any PL SQL procedure.

Different types of parameters in a PL SQL stored procedure with examples.

Please like & share the video.

Subscribe the Channel to keep watching intresting videos helpful for your career growth:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout different playlists:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout Important videos :

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Watch the complete sql and pl sql tutorial in Hindi to understand the necessary concepts of sql and plsql and to top any sql interview.
Рекомендации по теме
Комментарии
Автор

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:

CodingGlitz
Автор

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

RickandMorty__clipss
Автор

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

itsdragonav
Автор

Great Work..Please continue with your whole video series

bhuv
Автор

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

manishagupta
Автор

Nice lecture Aj Procedure Concept clear hua

bhanuchaurasia
Автор

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

pawanpetkar
Автор

Hi sir,
Plz guide us on realtime scenario 🙏

atishkumarbarik
Автор

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

youtubetrolls
Автор

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

kanikasuneja
Автор

Forward declaration in procedure explain kre plz

MUSTAQIM_BAGWAN
Автор

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

vijayarana
Автор

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

ll_ashu_ll
Автор

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

nomadickeshav
Автор

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

tarunsuthar
Автор

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

gauravgupta-rcuq
Автор

sir you wroye is instead of as is it allowed ?

prakashmore
Автор

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);


end;

viveksing
Автор

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

pranishsonone
Автор

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?

dineshkumarachari