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

Sql technical questions

777


Why do we use joins in sql?

502


what is the difference between union and union all? : Sql dba

548


What is pl sql record in oracle?

566


Mention what does the hierarchical profiler does?

561






What is primary key and unique key?

547


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

494


How to change sql*plus system settings?

544


What does over partition by mean in sql?

533


What is posting?

609


what is the difference between inner and outer join? Explain with example. : Sql dba

549


What is scope and visibility in PL/SQL?

600


Can we have two clustered index on a table?

566


Can we use ddl commands in pl sql?

560


Can we use delete in merge statement?

515