What is difference between a PROCEDURE & FUNCTION ?

Answer Posted / ace

A function is a special kind of procedure. A function
returns a value in its name. A function can return more
than one value if it returns a ref cursor.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is truncate ddl or dml?

751


What is the difference between clustered and non-clustered indexes?

796


How to convert comma separated string to array in pl/sql?

807


What are the packages in pl sql?

739


What does fetching a cursor do?

798






What is an inconsistent dependency?

761


What are the commands used in sql?

733


What is oracle sql called?

669


What is the location of pre_defined_functions.

837


how to include numeric values in sql statements? : Sql dba

766


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

753


Can we rollback delete command?

689


explain the difference between bool, tinyint and bit. : Sql dba

704


how to enter numeric values as hex numbers? : Sql dba

765


What trigger means?

730