Oracle interview question Procedure Vs Function | ORACLE PROCEDURE VS FUNCTIONS

I'm finding your videos very helpful. Thanks.

Can we fetch the last 3 records inserted without having an identity column nor date column ?

Can u please tell what is level and connect by

Hello
I’m looking for the starting videos bcz now I’m learning to start from beginning so plz let me know which one is the starting video in all the video like series numbers.

Sir, why we are using function. Because all operation should be done with procedure. But why using function???????
Pls tell me bro

Why do we use function when we have Procedure?

So unique and insightful

Hi Shiva
I received this question from my interviewer
Q: We can perform all actions inside the procedures then what is the need of functions?

Very helpful..thanks for amazing video

Thank you!!

SQL ful ah step step ah Tamil iruka sir unka vidro

Sir Tamil video iruka

Thanks Siva..

Can we use function inside stored procedure? pls share video on this bro

How can we add amount from last rows and give total output in current row?

High quality video not available

Hi Siva,
Where can I get the scripts used in all these videos?
Thank you.

thank u sivagaru

Hi Siva do you Take online Training for SQL Plsql

Hi,
Could you pl share a video on the similarities or difference between Loops and Cursors in PL/SQL?

Please bro,do video series on MACRO

Siva, a doubt. If fiction without keyword can be compiled. But we can't use it in both select and inside any other objects like proc function or in any java code?

Sir ...why we go for functions instead of a procedure ...can u pls explain this !?

Which book is better for reading for sql plsql.

Can you please explain difference between execution plan and explain plan

Helpful sir

Nice videos air

Video is not playing

Very helpful Siva,🙏 many thanks

Could you please explain the high level water mark topic bro

Autonomous transaction function, can you show us some examples

How to optimize a procedure in Oracle if the procedure having 1500 lines codes? Can u make a video ?

Thank you for the video..very useful...But the audio is very low....

Super explaination

Siva Academy is Super Siva Academy ❤️

Primary key does not have null and duplicates but foreign key does have why?

Nice explanation. I have 12plus years experience. But they asked this question.

Hi siva, can you help me to crack production support interview questions

It's wonderful.. Nicely explaining everything... Thankuu

Here you have mentioned functions having dml statement can be called from sql if it's autonomous transaction. Can you explain what is autonomous transaction functions. As per my information, are you referring pragma autonomous declaration in function. Please explain this point how we can call function having dml in sql

Fun fact. The creator is actually from Decatur, Georgia. He has to use this accent to get views.........just kidding. Great vid. Thanks alot.

Sir, can we call the procedure in select statment?

Voice is too low here ..otherwise videos are good

Please explain joins

Please also make a video on pipelined and parallel functions...

Siva, please create a detailed video on debugging

What is the autonomous transaction functions

Thank you for this nice video.
I have one query, Can funtion contains DDL statement?

Thanks Siva, could you help me to clarify the following question that was asked during one of my interview discussions ?

When a given task can be completed just by using a Procedure, what is use of doing the same task using Package ?

Great job please continue awesome videos sir