Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

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


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

2175


as a technical developer in oracle applications which type errors feced in your experience sofar

2150


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2429


A scenario for amount correction & how to use amount correction functionality in AP invoices

2078


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2009


Differentiate between transaction type and transaction source? : oracle accounts receivable

1063


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

2163


Give two methods you could use to determine what DDL changes have been made.

6678


3. Steps in UAT?

2355


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

1017


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?

2354


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2012


What is Tax Categories?

2047


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7561


What is the mandatory setup in cyclecount ?

2694