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
Sir I really like the way you teach, its very simple means anyone can understand it without any difficulty. I wish you all the best for this wonderful and knowledgeable video. Naresh Technology is number 1 because they have teachers like you
Hi sir, I am Sudheer from Krishna Reddy student previous but I don't understand language sir execution method. Vijay Kumar sir you are a really great so excellent explanation packages I love your explanation way Thanks regards Sudheer
Thankyou sir, Gyzz don't panic run this create or replace package p1 is procedure p_p1(e in number,s in number,n in varchar2); procedure p_p2(e in number); end; select * from emp; create or replace package body p1 is procedure p_p1(e in number,s in number,n in varchar2)is begin insert into emp(empno,sal,name) values(e,s,n); end p_p1; procedure p_p2(e in number)is begin update emp set sal=sal+100 where empno=e; end p_p2; end; execute p1.p_p1(4,400,'Vinay'); execute p1.p_p2(4);
Hi sir May I know why u wrote procedure in 2 times? In package we are declaring procedure that’s fine And In packages body also u r declaring the same again
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
Naresh i Technologies Can a package have a trigger?
I like that you talk slowly. Makes it clear to understand and not overwhelming. :)
Vijay sir very nice person ,I have attended SQL plsql course two years back ,his videos are very helpful .
Hi
Your way of teaching is excellent we can easily understand
Good job
superb explanation, very good real time example,very good teaching,infact NARESH technologies all video lectures are very good
Sir I really like the way you teach, its very simple means anyone can understand it without any difficulty. I wish you all the best for this wonderful and knowledgeable video. Naresh Technology is number 1 because they have teachers like you
sir thank you for your wonderful explations about pl sql.It was very useful!
Hi sir,
I am Sudheer from Krishna Reddy student previous but I don't understand language sir execution method.
Vijay Kumar sir you are a really great so excellent explanation packages
I love your explanation way
Thanks regards
Sudheer
Simple and clear explanation. Thank you sir....
really the way of explanation is very welll ! Thank you sir
Lot of thanks sir, may God always keep you happy
Very comprehensible lecture thank you sir.
wow superb video thank you for amazing lecture.
Thank you sir 🎉🎊your videos helpful to us
Superbly explained. Thank you Sir.
this is like how a perfect tutorial would be.
really thank you so much sir it help a lot
SIR your way of teaching is excellent may you provide link to oracle complete lengthy videos
Thankyou sir,
Gyzz don't panic run this
create or replace package p1 is
procedure p_p1(e in number,s in number,n in varchar2);
procedure p_p2(e in number);
end;
select * from emp;
create or replace package body p1 is
procedure p_p1(e in number,s in number,n in varchar2)is
begin
insert into emp(empno,sal,name) values(e,s,n);
end p_p1;
procedure p_p2(e in number)is
begin
update emp set sal=sal+100 where empno=e;
end p_p2;
end;
execute p1.p_p1(4,400,'Vinay');
execute p1.p_p2(4);
Super explanation sir..
Excellent, very nice, really appreciated.
VERY GOOD EXPLANATION
...Thanks for the nice explanation ......Can I pass value to a procedure using a bind variable ?
Super explanation
Is procedure n function within package once called is loaded into cache memory ?
Thank you sir
good explanation
Hi sir
May I know why u wrote procedure in 2 times?
In package we are declaring procedure that’s fine
And
In packages body also u r declaring the same again
Excellent Job Sir
Is there performance tuning videos in ur channel?? Like explain plan, bulk bind
package me archive hota hai ki nahi kaise dekhate hai. or package run hota hai ki nahi agar hota hai to usaki date kaise chk karte hai ..
You are genius
Nice sir
Nice explanation..
Hello Sir,
Plz help me out to teach how to work in Oracle 10 G expression edition. And Oracle 21 C
nice
can you please explain ref cursor and muliple return function. your tutorials really awesome.
U mentioned commit keyword in procedure..
I feel it's not required... May be I need to learn more to feel the use of it.;)
thanks a lot sir
Thankyou so much
Sir please provide videos on triggers and records
Sir I need trigger class video
Thanks
Sir how to install sql plus please tell
legacy