what is difference between procedure and function
- 10 Answers
- 14421 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 are the constraints available in sql?
Which is faster union or join?
Write a sql query to convert all character to uppercase after hypen.
Can you load data into multiple tables at once? : aql loader
how to use myisamchk to check or repair myisam tables? : Sql dba
What do you mean by table in sql?
what is online transaction processing (oltp)? : Sql dba
What are analytical functions in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Can we insert data into materialized view?
How do you declare a constant?
How to call a javascript function from pl sql?
How do I run a script in sql developer?
Is and as keyword in pl sql?
What is a full join?
