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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What are main difference between Stored Procedure and
Functions.

Question Posted / guru

Answer Posted / guru

stored procedure : It is Pre Compiled Code(PCode) it is stored
in Database. we can reuse without compile.

Function: It need compile whenever it will run.

Is This Answer Correct ?    15 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by a deadlock situation?

1063

What is oracle open database communication (odbc)?

974

How to delete all rows a table in oracle?

1021

IS it possible to built the oracle database without setting the kernal parameters?

2287

Explain what are clusters?

1055

Explain the use of grant option in imp command.

965

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1300

What is merge in oracle?

1002

How to define a record variable to store a table row?

1019

How to execute a stored procedure in oracle?

1040

How to find the duplicate rows count from employees table in oracle?

1051

How to check the server version in oracle?

1050

Who developed oracle & when?

956

What is oracle database client?

982

How to execute a stored program unit?

1017