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
How many commands are in sql?
What is posting?
Define commit?
How do I run a sql trace?
what is the difference between blob and text? : Sql dba
What is $$ in sql?
Where do we use pl sql?
How do I run a query in pl sql developer?
What are the parts of a sql statement?
How does rowid help in running a query faster?
What is the difference between partition and index?
What are the types of join and explain each?
What are the 3 types of behavioral triggers?
how to convert character strings to numeric values? : Sql dba
How do I partition in sql?
