A Procedure that performs an action. A Function that computes a value.

Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Question Posted / ezhumalai

10 Answers
55126 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / ezhumalai

A Procedure that performs an action.
A Function that computes a value.

We can call a Function in SELECT Statement.
We can't call a Procedure in SELECT Statement.

Is This Answer Correct ?

5 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is auto invoicing? Explain : oracle accounts receivable

1164

What are different types of transactions in ar? : oracle accounts receivable

1367

what are the API of GL,PO,AP

2309

How to clone the database using RMAN back

2308

What is the difference between oracle media recovery and crash recovery?

1210

please send me oracle pl/sql exp resume. and also faqs...

2546

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2257

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3641

Explain the payment term in ar. : oracle accounts receivable

1149

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1223

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2381

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2066

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2332

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1166

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1248