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
Explain the working of foreign key?
How would you pass hints to the sql processor?
What is the purpose of a secondary key?
how to calculate the difference between two dates? : Sql dba
What is the maximum database size for sql express?
What is sql character function?
Difference between truncate, delete and drop commands?
What is the difference between nvl function, ifnull function, and isnull function?
Can we join tables without foreign key?
What are the types of functions in sql?
What is join view in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
what is union, minus and interact commands? : Sql dba
difference between anonymous blocks and sub-programs.
How many scalar data types are supported in pl/sql?