Stored Procedures in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar 

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

Such a great explanation. Thank you sir.. (Playback speed 1.5x recommended)

Hi, Vijay Kumar, I would like to say you excellent explanation step by step. Thanks, lot Vijay Kumar. We can understand easily nice video all ORACLE PL/SQL Video

Thanks a lot sir..This explanation is much useful for me to understand about Stored Procedures.👍

Watched for 10 minutes , paused the video , liked the video and subscribed the channel , resumed the video

nice explanation.....before watching this video I was confused with other tutorials but now i'm good with stored procedure...thank u sir

Really the way of teaching is excellent and understanding......

Fantastic explanation sir...🙂Thank you so much... looking forward to more such content on pl/sql..

No one explain like this.. Thank you sir.

Very Good Explanation and also in easy way...Thanks

really am say your explaination is great sir ...thank u i understand clearly.

Excellent explanation ! Thank u sir. U are one of the best.Keep up

Easy to understand sir. Kindly use toad to run procedure sir

Crystal clear explanation 🔥🔥

Amazing Lecture Sir....Realy helpful😀😀

sir thank u so much... u made my concepts clear

Thank u sir very clear about procedures know

Nice video sir tq ❤

Excellent Teaching Vijay Sir

Excellent

Good explanation.... Thanks you sir.

Great Explanation gentleman.

Thank you Sir Very good accent

very good explanation sir, thank you.

sir how are you i am your student in rjc college 2013 you teached me dbms at that time

Excellent teaching boss

Nice Video Sir . Thanks a lot.

Please make a video on ‘how to data migrate from one table to another Table by using store procedure in oracle.

Nice Explanation ❤

Keep this nice work ahead ... thanks a lot

nicely explained 👌.

Very understandable...thank you sir, ❤️

Thank you

this video helped me alot....Thank you so much sir

Thanks for the video… Very Good explanation...whether we can pass value to procedure using bind variable ???

Good explanation sir

Super

GOOD EXPLANATION

Excellent explanation !

great explanation sir!

nice explanation

Excellent Teaching..

Excellent Sir...Was so meaningful for me

I liked this video, thank you for help me!

I liked this video, thank you for help me!

Thanks a lot sir

What is meant by compiled stored procedures and what is the use of it....

Hello sir,Can you please show an example where we are defining variable after IS

soooo gooooddd!!!

I have stored procedure in Oracle database. With IN parameter as varchar2. When I run this in c# it gives numeric error. I used value as "1300151". But when I do "130015" it works what is problem.

How to view the output of a stored procedure which does not have out parameter??

awesome Vijay sir...thanks a lot.

it is a good video

Thank you sir

Thanks sir

Can we perform ddl , dcl , tcl operations also in stored procedure plz answer

sir can u tell me how to write a concurrent program using stored procedure to send a file from one place to another in plsql and a host concurrent program to rename the file

How to create procedure and function of total order of each customer?

thank u sir

Here wt is the calling program name?

Show a small demo of only INOUT mode

Sir can you please explain NOCOPY in Oracle

Hi Sir i have one interview question if we excute stored procedure now it is excuting in 10 minuts same stored procedure excuting after 1 year it is taking 1 hour why what is the reason

Can any one help me to get the complete PLSQL Video for the same

guru g

can i create and insert a values in the table through procedures.plzzz tell me

SQL> CREATE OR REPLACE PROCEDURE 2 HIKE_SALARY (E IN NUMBER, AMT IN NUMBER, S OUT NUMBER) 3 IS BEGIN 4 UPDATE EMP SET SALARY=SALARY+AMT WHERE EMP_ID='E'; 5 COMMIT; 6 SELECT SALARY INTO S FROM EMP WHERE EMP_ID='E'; 7 END; 8 / Procedure created. SQL> variable k number SQL> SQL> EXECUTE HIKE_SALARY (1, 1000, :K); BEGIN HIKE_SALARY (1, 1000, :K); END; * ERROR at line 1: ORA-01722: invalid number ORA-06512: at "HR.HIKE_SALARY", line 4 ORA-06512: at line 1 Here is my table details: CREATE TABLE EMP( EMP_ID NUMBER, NAME VARCHAR2(200), SALARY NUMBER ); Can anyone help me to resolve this issue?

WHAT ABOUT IN OUT PARAMETER

please do video about views

Hi Vijay Kumar, I need help on SQL loader control file. I have a requirement where same column for different rows in a csv file has date in different format. While loading data in table through control file i need to load in the same date format. can you please help or provide me a contact so that i can get in touch with you

Why you declare bind variable k if you already declare out parameter

Anyone teel me software?

you dint showed how to use IN-OUT parameter in video ??

Hi, Vijay Kumar, I would like to say you excellent explanation step by step. Thanks, lot Vijay Kumar. We can understand easily nice video all ORACLE PL/SQL Video

Easy to understand sir. Kindly use toad to run procedure sir

Excellent

Thankyou sir,gyzz if facing problem then do this code: create or replace procedure raise_salary2(e in number,amt in number,s out number) is k number; begin update emp set sal=sal+amt where empno = e; select sal into s from emp where empno = e; end; execute raise_salary1(1,50,:k); execute raise_salary1(2,100,:k); select * from emp;

Thank youu sooo much sirr...I saw so many videos but can't find exact solution to solve procedure.By this method my procedure created successfully👌🏻

SP2-0552: Bind variable "K" not declared.

mampir di channel saya bos ku.

Very helpful sir.Thank u so much🙏.

Great job please continue awesome videos

Why cant we use s to output the salary why k

Thank You sir

هاايل