Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 52772 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / esakkiraja
One more diff between function and procedure
Functions can be used in sql query but procedure we can't
used in sql query
For eg:
tax is a function we can use like
select ename,tax(sal) from emp where ename='saki';
In this we can use.....
| Is This Answer Correct ? | 64 Yes | 6 No |
Post New Answer View All Answers
Where in the Oracle directory tree structure are audit traces placed?
What Are Cross Validation & Adi?
What is supporting issues GL AP and AR?
How would you determine who has added a row to a table?
What is the use of lockboxes? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is Restricted Mode of Instance Startup in Oracle?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
