diff b/w function and procedure?

Answer Posted / rupesh

function must return value whereas procedure may or maynot
return value
Call to Function can be encounter by using select
statement where as procedure can not be call in select
statement

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why indexing is needed?

747


Does sql support programming?

776


Is microsoft sql free?

793


Can you have more than one trigger on a table?

718


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

804


Where is pl sql used?

689


Which join is like an inner join?

734


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

893


What is a dynamic query?

770


What is a behavioral trigger?

709


What is thread join () in threading?

743


What is cascade in sql?

712


How to get each name only once from an employee table?

817


describe transaction-safe table types in mysql : sql dba

715


Can we insert in sql function?

782