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

define sql insert statement ? : Sql dba

552


Does a primary key have to be a number?

522


What is java sql driver?

550


What does over partition by mean in sql?

535


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595






What are the different types of database management systems?

532


Does sql backup shrink transaction log?

556


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6088


what is 'mysqld'? : Sql dba

546


What are pl/sql cursor exceptions?

576


How to write html code in pl sql?

582


how can we repair a mysql table? : Sql dba

540


Explain alias in sql?

584


What is write ahead logging in sql server?

564


What is a common use of group by in sql?

592