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

What is number function in sql?

523


How to call shell script from pl sql procedure?

618


Can we create a trigger on view?

481


How to download oracle sql developer?

650


explain the delete statements in sql

575






List the different type of joins?

566


Can we join 3 tables in sql?

488


What is mutating sql table?

600


How do I quit sql?

489


Is natural join and inner join same?

485


what is sql in mysql? : Sql dba

567


what is the difference between clustered and non clustered index in sql? : Sql dba

541


What is primary and foreign key?

587


Explain exception handling in pl/sql?

524


What is the default isolation level in sql server? : Transact sql

560