diff b/w function and procedure?

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


Please Help Members By Posting Answers For Below Questions

What are the types of records?

782


Can a table contain multiple foreign key’s?

770


How do I view stored procedures?

757


Why do we use partitions in sql?

756


How to place comments in pl/sql?

841


What is sql and how does it work?

770


How is data stored on a disk?

753


Does mysql support pl sql?

850


What is auto increment in sql?

849


Can we connect to postgresql using sql developer?

739


How can we make an if statement within a select statement?

762


what are the advantages of using stored procedures? : Sql dba

845


What is the left table in sql?

731


how to enter binary numbers in sql statements? : Sql dba

735


What is group by in sql?

795