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 rollback?
Explain the structure of pl/sql in brief.
What are the types of operators available in sql?
What is the use of desc in sql?
What is cost in sql execution plan?
Enlist the advantages of sql.
What is scalar data type in pl sql?
What is before trigger?
Explain the difference between 'between' & 'and' operators in sql
How do I install sql?
What is case function?
How do I get sql certification?
What is a unique key?
how to use 'mysql' to run sql statements? : Sql dba
Can we create clustered index without primary key?