Thank you! 😊 I'm glad you found the video helpful! If you could quickly master any advanced SQL skill, what would it be and why? Your input enriches our content! 🌟🚀
This is the entire PL/SQL course. By the way Where do you currently stand in your SQL proficiency: beginner, intermediate, or advanced? Your perspective is valuable! 😊🌟
Dear sir Please Provide Video 1)Pipelined function vs Table function 2)how to convert the non partition table to Partition Table 3)advantages of Partition 4)Normal table Verses Partition Table
create or replace function circleArea (r in number) return float is pi constant number(4,3) := 3.142; begin return (r * r)*pi; end; declare r number := 4; ans float; begin select circleArea(r) into ans from dual; dbms_output.put_line('Area of cicle having radius ' || r || ' = ' || ans); end;
Hi Manish, Please tell how to call procedures in plsql developer? The one you have showed in sql developer isn't wotki g in plsql dev'r. Please help me
how do i create a function for table, say if am taking the input from a user..and i want to print the table for that number using a function created by me.
Hello Manish...i have written the below code...it's compiling with errors...plz suggest me what to do? set serveroutput on; create or replace function rect_area(height number(4),width number(4)) return number is area number(4); begin area := height * width; return area; end; / error is : Error(1,33): PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % default character The symbol ":=" was substituted for "(" to continue. Error(1,48): PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % default character The symbol ":=" was substituted for "(" to continue.
Thanks for writing to me. The function is correct except that you specified the data width along with the datatype of your parameter. While defining the PL/SQL subroutines we do not write the data width, we only write the datatypes of their parameters. here is the correct code SET serveroutput ON; CREATE OR REPLACE FUNCTION rect_area( height NUMBER, width NUMBER) RETURN NUMBER IS area NUMBER(4); BEGIN area := height * width; RETURN area; END; / I suggest you , to watch the PL/SQL tutorial 38 carefully where I have explained the syntax th-cam.com/video/6OJIrPx61mU/w-d-xo.html Keep writing the code. All the best. Please do make sure to LIKE, SHARE and SUBSCRIBE. You can now also connect with me on my Facebook Personal Page: fb.me/TheRebellionRider Page for RebellionRider.com updates: fb.me/RebellionRider.official I am also very active on Twitter: twitter.com/RebellionRider Hope to see you there soon. Thanks and have a nice day.
create or replace function rectArea(l in float, b in float) return float is begin return (l*b); end; declare l float := 1.2; b float := 1.2; ans float; begin select rectArea(l,b) into ans from dual; dbms_output.put_line('Area of rectangle with l and b = ' || l || ', ' || b || ' = ' || ans); end;
![[안방1열 직캠4K] 베이비몬스터 치키타 'DRIP' (BABYMONSTER CHIQUITA FanCam) @SBS Inkigayo 241110](http://i.ytimg.com/vi/tnlxo79cAqY/mqdefault.jpg)
😊very very helpful video
Thank you! 😊 I'm glad you found the video helpful! If you could quickly master any advanced SQL skill, what would it be and why? Your input enriches our content! 🌟🚀
A very good channel to leran SQL n PL/SQl.
thanks for both sql and plsql tutorials , you are really doing a great job sir
Great 🎉🎉 we need more from plsql course in details anything u u missed in this series,
This is the entire PL/SQL course. By the way Where do you currently stand in your SQL proficiency: beginner, intermediate, or advanced? Your perspective is valuable! 😊🌟
thanks for providing plsql videos,i learnt a lot from you.
I have to learn this for work. You're my hero!
Thank you so much. I am truly glad that you find my content helpful.
Manish great tutorials, but one suggestion from me could you find some other opening phrase for your videos? Thanks
thank you so much for the such great series about pl/sql
Thanks very much, Sir.
Thanks a lot for this tutorial :)
Dear sir Please Provide Video 1)Pipelined function vs Table function
2)how to convert the non partition table to Partition Table
3)advantages of Partition
4)Normal table Verses Partition Table
YOU ARE AMAZING MANISH !!!!
Thank you so much your appreciation means a lot to me.
Are these syntax now also valid
Of course they are.
Thankyou sir
Is it possible to return a whole table in a function?
create or replace function circleArea (r in number)
return float
is
pi constant number(4,3) := 3.142;
begin
return (r * r)*pi;
end;
declare
r number := 4;
ans float;
begin
select circleArea(r) into ans from dual;
dbms_output.put_line('Area of cicle having radius ' || r || ' = ' || ans);
end;
Hi Manish, Can you explain how to create function which returns multiple values
function will always return a single value
great video but your screen display is very tiny
Manish, please do some videos on recovery and backup for Oracle 11g, using RMAN.
How to concate strings from a table using ceate or replace function
Sir plz tell functions without any parameter n how it works whts its use
Hi Manish,
Please tell how to call procedures in plsql developer? The one you have showed in sql developer isn't wotki g in plsql dev'r. Please help me
Hi- great vid BUT how would you write the SELECT statement to call the example function in this video?? SELECT circle_area from dual; ??
set serveroutput on;
declare
v_result number (7,3);
begin
select Circle_area(25) into v_result from dual;
dbms_output.put_line(v_result);
end;
/
In function how I return data tabular form
hoye papa jiiiii
Hey
bro.....plz upload procedures
how do i create a function for table, say if am taking the input from a user..and i want to print the table for that number using a function created by me.
I want to join function and table how
why is your link not working?
Hello Manish...i have written the below code...it's compiling with errors...plz suggest me what to do?
set serveroutput on;
create or replace function rect_area(height number(4),width number(4)) return number is
area number(4);
begin
area := height * width;
return area;
end;
/
error is :
Error(1,33): PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % default character The symbol ":=" was substituted for "(" to continue.
Error(1,48): PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % default character The symbol ":=" was substituted for "(" to continue.
Thanks for writing to me.
The function is correct except that you specified the data width along with the datatype of your parameter. While defining the PL/SQL subroutines we do not write the data width, we only write the datatypes of their parameters.
here is the correct code
SET serveroutput ON;
CREATE OR REPLACE FUNCTION rect_area(
height NUMBER,
width NUMBER)
RETURN NUMBER
IS
area NUMBER(4);
BEGIN
area := height * width;
RETURN area;
END;
/
I suggest you , to watch the PL/SQL tutorial 38 carefully where I have explained the syntax th-cam.com/video/6OJIrPx61mU/w-d-xo.html
Keep writing the code. All the best. Please do make sure to LIKE, SHARE and SUBSCRIBE.
You can now also connect with me on my Facebook
Personal Page: fb.me/TheRebellionRider
Page for RebellionRider.com updates: fb.me/RebellionRider.official
I am also very active on Twitter: twitter.com/RebellionRider
Hope to see you there soon. Thanks and have a nice day.
Tnx Manish...it's worked for me..understood now :)
create or replace function rectArea(l in float, b in float)
return float
is
begin
return (l*b);
end;
declare
l float := 1.2;
b float := 1.2;
ans float;
begin
select rectArea(l,b) into ans from dual;
dbms_output.put_line('Area of rectangle with l and b = ' || l || ', ' || b || ' = ' || ans);
end;
The only thing I don't get it is why you haven't assigned a value to radius and still work
He gave the value of radius (25) while he was calling functions in pl sql block
Or you can simply write select circle_area(25) from dual.. :)
How to update salary for each dept using function?
He is trying to copy code with Harry style of speaking
Yeh video 5-6 saal purani hai chomu.