FUNCTIONS IN PL SQL WITH EXAMPLES | PL/SQL TUTORIAL

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?

Thank you 💞💞

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

Thanks you 🤗 I understand the concept 😊

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..

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

Thanks alot .. very good explanation

THANK YOU SO MUCH

Thank you a lot for your explanation .
Greeting from Morocco <3 .

Nice

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

Thank you so much ....

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

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

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

Good explanation is this full SQL PLC course

Very helpful

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

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

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 ?

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

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

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.

more videos on PLSQL PLZZ

please make video on Package too???

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

Thank you ! As usual good quality good explanation

There are so many videos in you tube.I left all of them and came to see your tutorial

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

nice explanation. Thankyou very much.

Could u please make plsql interview questions.

could you please make more examples using some scenarios .so that we will have clear cut idea about it.

Nice mam thanks 👍

yes, it is good explained indeed - thx

Good job

Simple and easily explained...please make more videos

Can you help me?

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

You are really creating a good content...

Which college you are?