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 are the types of records?
Can a table contain multiple foreign key’s?
How do I view stored procedures?
Why do we use partitions in sql?
How to place comments in pl/sql?
What is sql and how does it work?
How is data stored on a disk?
Does mysql support pl sql?
What is auto increment in sql?
Can we connect to postgresql using sql developer?
How can we make an if statement within a select statement?
what are the advantages of using stored procedures? : Sql dba
What is the left table in sql?
how to enter binary numbers in sql statements? : Sql dba
What is group by in sql?