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 to include comments in sql statements? : Sql dba
What is primary key in db?
How do we accept inputs from user during runtime?
how to drop an existing index in mysql? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are local and global Indexes and where they are useful.
What is oracle sql called?
Is pl sql better than sql?
how would concatenate strings in mysql? : Sql dba
What is sql dialect?
Are left and right joins the same?
What are crud methods?
Is sql a oracle?
How do I pipe the output of one isql to another?
How many joins in sql?