what is difference between procedure and function

Answer Posted / shyam katwal

The only difference between procedure and function is:
Function returns a value
whereas
Procedure does not return a value

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is natural join same as inner join?

702


Why primary key is required?

744


What is user defined functions?

759


What is write ahead logging in sql server?

792


What is dml with example?

784


Does pl/sql support create command?

783


what are the types of subquery? : Sql dba

808


What is sql table?

719


how to use 'mysql' to run sql statements? : Sql dba

779


How can you tell the difference between an index and a view?

724


What is cross join sql?

715


Mention what is the function that is used to transfer a pl/sql table log to a database table?

691


Explain the advantages and disadvantages of stored procedure?

885


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

899


What is cross join example?

769