User Defined Functions in PLSQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar

[@NareshIT]

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

[@swati8201]

Your all video is so awesome that any one can be good in PL/SQL Programming .. A salute to you sir :)

[@shridharadevadiga7144]

Awesome explanation sir.....................

[@snehil_tripathi9583]

great explaination sir
Thank you 🖒

[@jaspreetkathuria343]

Question 1:
Create a procedure that accepts 3 parameters, the first two are of mode IN with number as
their datatype and the third one is of mode OUT in form of Varchar2. The procedure will
compare the first two numbers and output the result as EQUAL, or DIFFERENT.
Create a second procedure called L8Q1 that accepts the two sides of a rectangle. The
procedure will calculate the area and the perimeter of the rectangle. Use the procedure
created previously to display if the shape is a square or a rectangle. The following are the
example on how we execute the procedure and the expected output.
SQL > exec L4Q1(2,2)
The area of a square size 2 by 2 is 4. It`s perimeter is 8.
SQL > exec L4Q1(2,3)
The area of a rectangle size 2 by 3 is 6. It`s perimeter is 10.

[@be-a-76-abhishektare55]

Best video to learn functions

[@shreyapatel2009]

Sir you are grate!! Thank you sir........

[@bhavesh6674]

Create a function named 'find_stadium_count' which takes k_city_id as
input and returns the stadium_count, i.e., it returns the number of
stadiums in the city which its corresponding id as k_city_id.
Use the skeleton file, to create the function.
Function name: find_stadium_count
Input parameter : k_city_id with data type as int.
Output parameter : stadium_count with data type as int.
Table used : k_venue.
when i tried i am getting compilation error plz help me out sir...!
please write a function for the given specifications sir?

[@appustorage824]

Am only see your videos when reading Oracle and purchased your text book from naresh it sir .

[@DheerajKumar-hi8jz]

What is dual??

[@kesavareddy1767]

Nice explanation sir

[@jaspreetkathuria343]

Can you help me in this
Create a pseudo function called pseudo_fun that accepts 2 parameters represented the
height and width of a rectangle. The pseudo function should return the area and the
perimeter of the rectangle.
Create a second procedure called L4Q2 that accepts the two sides of a rectangle. The
procedure will use the pseudo function to display the shape, the area and the perimeter.
SQL > exec L4Q2(2,2)
The area of a square size 2 by 2 is 4. It`s perimeter is 8.
SQL > exec L4Q2(2,3)
The area of a rectangle size 2 by 3 is 6. It`s perimeter is 10.

[@shivapotnuru662]

sir, i need for answer with 2 examples....

[@krzysztofs6149]

Thanks!

[@nageshnethi7910]

plz upload total SQL & PL SQL videos.....plz sir

[@galisateesh933]

Sir function calc ఏదైన ఉండచ్చా Sir

[@shivapotnuru662]

can we call functions inside the procedure and can we call procedure inside the function in sql? plz tell me sir.......i need for 2 examples regarding above problems

[@manojsaruk3624]

Yes , we are able to call function inside the procedure, but no idea about calling procedure inside the function . I had implemented it in our company.

[@junaidbinabduljabbar8189]

How to create Function in pgsql that
if id=0
then insertion operation will be done
elsif id>0 and is_active=1 then
updation operation must be done
elsid id>0 and is_active=0
then update
only
is_active=0

[@junaidbinabduljabbar8189]

please help

[@sharmilakondakamarla5816]

Sir we must use capitals in' creating or replace function' line

[@manojsaruk3624]

PL SQL is not a case sensitive

[@anagha6789]

Why from dual is used?

[@Ishika_b222]

It's a dummy table

[@AyazurRahman]

What is "from dual" in the end of example function ?

[@bhargavkumar8522]

It is a dummy table

[@manojsaruk3624]

@@bhargavkumar8522 can you explain it briefly.

[@priyaaofficial7]

​@@bhargavkumar8522 ⁉️

[@protograde2723]

I felt sleepy.

[@light-heartedpleasure6637]

What is dual?

[@rohankayande2554]

DUAL is virtual column in sql ,which performs only arithimatic and date operations like +,-,/* and sysdate

[@Venu_P]

Dual is a default table in Oracle which contains one row and one column in a table

[@joanmahimaidoss4577]

Dual is dummy table. it has one row and one column. Default value x. It's used to process our own data.

[@sowmiyas813]

Sir I'm not understand

[@omkarbhalerao4551]

SYNTAX FOR SQL * PLUS (other_way round)
1 SQL> CREATE OR REPLACE
2 FUNCTION CALC ( a IN number, b IN number , op IN varchar)RETURN number
3 is
4 RESULT NUMBER(10);
5 begin
6 if op ='+' then
7 result:= (a+b);
8 elsif op ='-'then
9 result :=(a-b);
10 elsif op ='*' then
11 result:= (a*b);
12 else
13 result :=(a/b);
14 end if;
15 RETURN result;
16 end;
17 /