Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 52533 Views
- TCS, I also Faced
- E-Mail Answers
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
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is mrc and what is its use? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is an Oracle database Full Backup?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is auto invoicing? Explain : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
What are different types of transactions in ar? : oracle accounts receivable
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is an Oracle database Partial Backup?
What is Restricted Mode of Instance Startup in Oracle?
