Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16864 Views
- MCN Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / p.rajasekar
Function:
1.Function Always Return values
2.We can call the function in select Query
3.We can return more than one values using Out put
paramaetes
4.Genrally we can use function as calculatevalues
5.We can insert,update or delte value with the help
function in a select query
Procedure:
1.Procedure doesnot always return value
2.We can't call procedure in Select query
3.We can return more than one value using Out put
parameters in procedure
4.Genarally procudures are using as business logic
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do you update a value in sql?
What is not equal in sql?
Explain ddl statements in pl/sql?
What are the types of keys?
How do I start sql from command line?
What are the two types of exceptions.
what are all the different types of indexes? : Sql dba
What are all the common sql functions?
Do we need to create index on primary key?
Can we use distinct and group by together?
How many sectors are in a partition?
What is PL/SQL Records?
What is cartesian join in sql?
What is on delete set null?
How to run sql statements through the web interface?
