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

3. Steps in UAT?

2468


Explain how to close periods in ar. : oracle accounts receivable

1372


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

2560


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

1154


What is chargeback invoice? How do we create it? : oracle accounts receivable

1377


What is Restricted Mode of Instance Startup in Oracle?

1231


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

1248


which one is currently in used software cmpanies.

2194


where the dff data will be stored

2534


Explain the payment term in ar. : oracle accounts receivable

1149


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

1210


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2433


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2158


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

1367


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1345