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
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
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
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?
Vijay sir very nice person ,I have attended SQL plsql course two years back ,his videos are very helpful .
I like that you talk slowly. Makes it clear to understand and not overwhelming. :)
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
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
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!
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);
Simple and clear explanation. Thank you sir....
SIR your way of teaching is excellent may you provide link to oracle complete lengthy videos
Lot of thanks sir, may God always keep you happy
really thank you so much sir it help a lot
Superbly explained. Thank you Sir.
this is like how a perfect tutorial would be.
really the way of explanation is very welll ! Thank you sir
Very comprehensible lecture thank you sir.
Thank you sir 🎉🎊your videos helpful to us
wow superb video thank you for amazing lecture.
...Thanks for the nice explanation ......Can I pass value to a procedure using a bind variable ?
Thank you sir
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.;)
Is procedure n function within package once called is loaded into cache memory ?
VERY 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
Super explanation sir..
Excellent, very nice, really appreciated.
Is there performance tuning videos in ur channel?? Like explain plan, bulk bind
Super explanation
You are genius
can you please explain ref cursor and muliple return function. your tutorials really awesome.
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 ..
good explanation
Excellent Job 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 sir
thanks a lot sir
nice
Thankyou so much
Sir please provide videos on triggers and records
Thanks
legacy
Sir how to install sql plus please tell
Sir I need trigger class video