Answer Posted / malkeet kaur
1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between jpql and sql?
What is the difference between alter trigger and drop trigger statements?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What are the types of views in sql?
What is aggregate function in sql?
Who is the owner of mysql database?
What is the most restrictive isolation level? : Transact sql
What is auto increment?
how to use 'mysql' to run sql statements? : Sql dba
How to fetch alternate records from a table?
Explain the difference between rename and alias?
What is sql in java?
How do you declare a constant?
How do I access sql anywhere database?
What is offset in sql query?