What is difference between a PROCEDURE & FUNCTION ?
Answer Posted / surajit pathak
We can use in,inout,out parameters in functions also.
The most important difference is we can use functions in
normal sql queries if it is not containing any out
parameters.
but we cann't use procedures in sql queries....
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is union and union all keyword in sql and what are their differences?
How do you run a query?
What do you mean by dbms? What are its different types?
How do I run a pl sql program?
What are the indexing methods?
What is sqlca in powerbuilder?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What are the different type of joins in sql?
How we can update the view?
What is sqlca in db2?
How does sql profiler work?
What is the difference between partitioning and sharding?
What is view? Can we update view
does sql support programming? : Sql dba
How many databases can sql express handle?