what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?

Answer Posted / gavini srikanth

function can return value,procedure may or may not return
value,through procedures can store images

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the working of foreign key?

557


How would you pass hints to the sql processor?

537


What is the purpose of a secondary key?

519


how to calculate the difference between two dates? : Sql dba

560


What is the maximum database size for sql express?

544






What is sql character function?

550


Difference between truncate, delete and drop commands?

565


What is the difference between nvl function, ifnull function, and isnull function?

607


Can we join tables without foreign key?

528


What are the types of functions in sql?

575


What is join view in sql?

522


What is the starting oracle error number? What is meant by forward declaration in functions?

551


what is union, minus and interact commands? : Sql dba

674


difference between anonymous blocks and sub-programs.

628


How many scalar data types are supported in pl/sql?

532