what is difference between procedure and function

Answer Posted / monalisa dalbehera

Function always return a single value
Procedure may or may not return a value.
A procedure can return more than one value by using out
parameter.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rtm in testing?

783


what are the 'mysql' command line options? : Sql dba

770


What are the steps for performance tuning.

1056


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

770


Write the command to remove all players named sachin from the players table.

943


What are sql injection vulnerabilities?

713


How to combine two stored procedures in sql?

833


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2788


Why triggers are used?

772


What are the popular database management systems in the it industry?

754


What is the difference between row level and statement level trigger?

749


Can you selectively load only those records that you need? : aql loader

806


What is a pl/sql block?

780


How do I quit sql?

701


Is join an inner join?

738