Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.


YOU ARE HERE: HOME Questions What is the difference between function and stored procedure

Function vs Stored procedure

View(s): 16242

What is the difference between function and stored procedure?

Answer 1)
  1. Procedure can return zero or n values whereas function can return one value which is mandatory. 
  2. Procedures can have input,output parameters for it whereas functions can have only input parameters. 
  3. Procedure allow select as well as DML statement in it whereas function allow only select statement in it. 
  4. Functions can be called from procedure whereas procedures cannot be called from function. 
  5. Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function. 
  6. We can go for transaction management in procedure whereas we can't go in function.
  7. Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
  Asked in:  LiquidHub   Expertise Level:  Intermediate
  Last updated on Wednesday, 22 September 2010
5/5 stars (13 vote(s))

Register Login Ask Us Write to Us Help