what is difference between procedure and function
- 10 Answers
- 14622 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
What does sign mean sql?
What are triggers and its uses?
what is the syntax for using sql_variant_property? : Transact sql
Which is faster subquery or join?
what is a composite key ? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
How to start the command-line sql*plus?
Mention what plvcmt and plvrb does in pl/sql?
What are the popular database management systems in the it industry?
What is data types in sql?
What are types of indexes in sql?
Can delete statement be rollbacked?
How many scalar data types are supported in pl/sql?
Difference between table function and pipelined function?
Why do we create stored procedures & functions in pl/sql and how are they different?
