What is difference between a PROCEDURE & FUNCTION ?
- 6 Answers
- 10730 Views
- Satyam, I also Faced
- E-Mail Answers
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
How many types of triggers exist in pl/sql?
What is the difference between an inner and outer join?
What are system versioned tables?
what is the syntax used for partition in tsql? : Transact sql
Differentiate between syntax and runtime errors.
What is the current version of sql?
What is rename command in sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
what are all the different types of indexes? : Sql dba
what is 'mysqld'? : Sql dba
Are subqueries better than joins?
Why commit is not used in triggers?
Explian rowid, rownum?
what is an index? : Sql dba
How does an execution block start and end in pl sql?
