Oracle interview question Procedure Vs Function | ORACLE PROCEDURE VS FUNCTIONS

preview_player
Показать описание
Difference between Procedure and Function

List of all the SQL and PLSQL interview questions
  1. Siva Academy
  2. oracle sql interview questions for experienced
  3. oracle sql plsql interview questions
  4. oracle interview questions
  5. oracle pl sql interview questions
  6. oracle pl sql interview questions and answers
Рекомендации по теме
Oracle interview question 0:07:30

Oracle interview question Procedure Vs Function | ORACLE PROCEDURE VS FUNCTIONS

Difference Between Function 0:05:33

Difference Between Function And Procedure In PL-SQL | Oracle/ PL-SQL Interview Question

Oracle Interview Question 0:20:19

Oracle Interview Question - Can we use OUT and INOUT parameter in function

Oracle PL SQL 0:06:29

Oracle PL SQL interview question difference between VARRAY NESTED TABLE ASSOCIATIVE ARRAY

Oracle Interview Question 0:09:00

Oracle Interview Question - oracle %rowtype and %type

Top 50 Oracle 0:42:28

Top 50 Oracle Interview Questions and Answers | Questions for Freshers and Experienced | Edureka

Oracle Interview Question 0:10:50

Oracle Interview Question - oracle difference between view and materialized view

Oracle PL SQL 0:05:35

Oracle PL SQL interview question | oracle constraint with DEFERRABLE NOVALIDATE option

Oracle Fusion and 0:00:56

Oracle Fusion and EBS Interview Questions Raised from Different MNC Companies

SQL 'difference between' 0:08:20

SQL 'difference between' interview questions (part 1)

DIFFERENCE BETWEEN STORED 0:02:18

DIFFERENCE BETWEEN STORED PROCEDURES AND FUNCTIONS IN SQL | SQL Interview Question | IQBees

Oracle interview question 0:07:23

Oracle interview question difference between null functions | NVL vs NVL2 vs NULLIF vs COALESCE

Oracle PL SQL 0:05:32

Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

What is the 0:04:11

What is the difference between Stored Procedure and Functions ?

Top 60 PL/SQL 0:59:25

Top 60 PL/SQL Interview Questions & Answers 2024 | Oracle PL/SQL Interview Questions | MindMajix

Oracle Interview Question 0:14:11

Oracle Interview Question oracle index related questions

Oracle 12c Features 0:07:42

Oracle 12c Features - SQL Interview Question

Oracle Interview Question 0:23:14

Oracle Interview Question - oracle index related questions - BTREE index in oracle

Oracle interview question 0:06:49

Oracle interview question : Can we use DML and DDL statements inside function?

Oracle PL SQL 0:09:32

Oracle PL SQL interview question | Oracle Table Function

TOP 23 SQL 0:18:31

TOP 23 SQL INTERVIEW QUESTIONS & ANSWERS! (SQL Interview Tips + How to PASS an SQL interview!)

Tell Me About 0:05:15

Tell Me About Yourself | Best Answer (from former CEO)

Top 25 SQL 0:26:21

Top 25 SQL Interview Questions and Answers(The BEST SQL Interview Questions)

5 Most Common 0:00:44

5 Most Common Interview Questions!

Комментарии
Автор

All the videos from Siva Academy are super.

sivaveeramallu
Автор

Great Videos thanks, just pointing something, functions can be called in SQL statement so far as the function doesn't contain any formal parameter mode OUT or IN OUT

renevillalta
Автор

Very Good and Helpful Information Also Your teaching style is very good Sir

sagarjadhav
Автор

Great Siva. Thank you for your videos. Very clear explanation.

prathyush
Автор

Thank you so much for the video and sharing

akware
Автор

Great job please continue awesome videos sir

kunnudev
Автор

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

rainbowclubkerala
Автор

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

digv
Автор

Very helpful..thanks for amazing video

sonukumar-nxtt
Автор

All your videos are very nice easy to understand and having sense.

abhisheknegi
Автор

I have gone this question many time in first technical round

mayurhajare
Автор

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?

bharathipandian
Автор

Which book is better for reading for sql plsql.

VijayKumar-eqte
Автор

I'm finding your videos very helpful. Thanks.

sciencemaster
Автор

Hello shiva, your vedios are really awesome,
Could you please make a vedio on deterministic Function and pipelines functions with real time examples.
Thanks in advance.

akashsoni
Автор

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

sankareeswaran
Автор

Can you please explain 4 th point with example in case of function?

ankursrivastava
Автор

RETURN keyword in procedure will take the call to the calling environment and exit from the program
In function, RETURN will return the value and exit from the program....

I'm not commenting as you are wrong.. I'm just extending the statement

premgona
Автор

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

sheikabdullah
Автор

Dear Siva, thanks for posting such valuable concepts.

Can we have out parameters in function?

muralisethi