What is difference between a PROCEDURE & FUNCTION ?
Answer Posted / chandrasekar.ramasamy
Function accepts only in parameter but procedure accepts
in,out and inout
Function mostly used for mathamatical calculations
But procedure used to execute business logics
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
What is pl sql variable?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can one improve the performance of sql*loader? : aql loader
What is ttitle and btitle?
how to delete an existing column in a table? : Sql dba
define data blocks ? : Sql dba
What is Collation Sensitivity ? What are the various type ?
What is consistency?
explain advantages of innodb over myisam. : Sql dba
What does sql stand for?
Is sql workbench free?
What is $$ in sql?
What is the difference between inner join and outer join?
What is data definition language?
How many clustered indexes can be created on a table?