1. Categories >> Software >> Databases >> Oracle >> Oracle AllOther
  2. Suggest New Category

Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Question Posted / suresh

Answer Posted / suresh

Function must return one value
Procedure may or may not return one or more values.
Can call functions in Sql statements
we can't call a procedure in sql statements
Functions can not return images
procedure returns images

Is This Answer Correct ?    24 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1759

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1953

What view would you use to determine free space in a tablespace?

1769

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2352

what is difference between inner join & nested query or subqueries

2480




Where in the Oracle directory tree structure are audit traces placed?

2116

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

667

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1981

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1767

What is auto invoicing? Explain : oracle accounts receivable

610

types of receipts and detail desription about recipts and tables effected by receipts?

1623

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

720

What do you mean by hz_ in customer tables? : oracle accounts receivable

635

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1800

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

609