FUNCTIONS IN PL SQL WITH EXAMPLES | PL/SQL TUTORIAL

Hello everyone,
In this video we'll see how functions work in PL SQL Oracle with appropriate examples. If you found the video helpful, please subscribe to the channel.
Thanks,
Sadia.

[@asmaalanazi3187]

As using simple words and tools and short video but most understandable video and not complicated like many videos. thank you so much and explanation is great.

[@ummesalmabadri3884]

Wooww instead of going to views you have on your video I chose to watch it....and trust me it was worth it........I got all the points.....nd I must say u've got such a beautiful voice.....thanksss madam

[@hamzaabaichi8361]

Thank you a lot for your explanation .
Greeting from Morocco

[@lukskywaker]

Thanks, great work.
In the above program...
I presume the function declaration needs to become under declare statement, without the need for create or replace.. just start wth the function and then function name... Declare will also contain the c result variable as well..

[@MuhammadUsman-b7u8r]

it really helped me a lot thank u for making the concept clear and simple

[@Gautam_Pathsala]

Nice way to teach...I have little bit of confusion before I have seen your video , now it's clear..

[@girishbhargava6367]

Your explanation is good, but you can go deeper in the topic, by explaining it with a proper table and running the program.

[@mafikulislam3469]

Simple and easily explained...please make more videos

[@sakshichouhan7417]

Hi Sadia,
can we directly run this function like we use to run a procedure with the EXECUTE COMMAND?
like while running a procedure we use to write execute Procedure_name;
similarly can we right (in this case as) execute function_name?

[@antonmariadas7747]

Thank you ! As usual good quality good explanation

[@sanjaysivagami6593]

Tomorrow my semester. Now Im learning from you. Much helpful ❤

[@mohitdodiya3989]

Thanks ma'am 👍 it is very useful for me .

[@bikashmahato2874]

Thanks you 🤗 I understand the concept 😊

[@YashDEVELOPER12]

Thanks alot .. very good explanation

[@IGNIS97]

Video is excellent but aapne jo pehle function ka exmaple diya usse pehle customer ka table bana aur usko excute krna sikhana chahiye tha bcz kuch log bhul gaye hote hai ki kaise table banana chahiye..❤

[@StayMotivatedWithMee-s8z]

Beauty with brain deadly combination ❤😅

[@shahanaz967]

Could u help me how to create a function to return true or false if the employee is there or not based on employee id

[@aksharaverma6452]

nice explanation. Thankyou very much.

[@ManjiriKadu]

Very helpful

[@sathishbabumv8900]

Thank you so much ....

[@mohankumarm9430]

You are really creating a good content...

[@sarcastiXperimental]

THANK YOU SO MUCH

[@varshamk3105]

Hi i have a doubt : is procedure and function same? only thing is that functions return some value but you can do the same in procedure also right ?

[@Ijayrushi]

So, the procedure can return zero, one or multiple values but in function it can only return one value which is mandatory.

[@Sergio-td7mn]

yes, it is good explained indeed - thx

[@sagarnayak2420]

Thank you 💞💞

[@kshitijakulkarni6716]

Good explanation is this full SQL PLC course

[@laxmidharnayak4097]

Write a PLSQL cursor programme to display total salary with out using sum function..pls ma'am explain the Question..

[@macjohn7056]

Thank you mam....😍😍😃😃😃

[@doraithenu979]

Could u please make plsql interview questions.

[@Sreeja_blogs]

Nice mam thanks 👍

[@sathishbabumv8900]

Dear team pls can u make a plsql interview related concept vidio or send plsql interview questions...

[@zeroandone5253]

Good job

[@payalkarkande2409]

What is dual table in oracle ? Can u please make video on this it will be very helpful for me.

[@subhashr6156]

It is a one row one column table

[@SriDevi-zg3yj]

default table which return x

[@RamkrishnaBejjanki]

Nice

[@vishnuk9137]

Why we are giving open and closed brackets after function name?
C:=totalcust();

[@Hahe2023]

We are calling the function and storing it in a variable c

[@waqarahmad7840]

hi mam i am searching window function totrial , so if u have plz send link

[@arhamnaik3087]

is it possible to assign a value in DECLARE .....?

[@crackconcepts]

Yess!

[@Awanish7755]

Yes

[@acemaster65]

00:01 Functions in PL/SQL return a value.
00:29 Defining Functions in PL/SQL
00:58 PL/SQL allows variable declaration and SQL statement execution within functions
01:28 Create or replace function in PL/SQL
01:58 Assigning values to variables in PL/SQL
02:35 Returning total count from customers table.
03:08 PL/SQL functions can return values of specific data types
03:37 Explanation of function usage in PL/SQL

[@mohankumarm9430]

Which college you are?

[@yondrstudio5774]

Can you help me?

[@kaustavdutta9718]

CREATE OR REPLACE FUNCTION find_credit_card(card_no IN VARCHAR2(255))
RETURN VARCHAR IS
holder_name VARCHAR(255)
BEGIN SELECT name INTO holder_name from credit_card where card_number = card_no;
RETURN(holder_name);
END; /
Getting compilation error

[@한슬기-z8f]

240228