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...

what is difference between procedure and function

Answer Posted / venky

Function can be use in SQL queries
Procedure can't be used in SQL queries

Function call by an Expression
Procedure call by Statement

The Main diff is DML
Through procedures we can insert,update,delete data from
Table
Through Functions we can't

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain oracle apps architecture.

1301


Do you know where we can check the status of po?

1361


can we get profile values in report without using user exists is it possible how?

2933


In hierarchical structure of a database? we have write query from where we should start?

2298


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2258


What do you understand by soa?

1193


What is oracle soa suite?

1297


How can you achieve loose coupling in soa framework?

1275


what is the differences between internal requisition and internal sales order?

2705


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2154


In oracle application how do you debug or trace errors?

1175


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2177


testing tools?

2298


What do you understand by concurrent programs?

1143


what are the balancing segments in AR?

2149