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 application trigger?
How to rename a column in the output of sql query?
Explain normalization and what are the advantages of it?
What is the use of desc in sql?
Write the command to remove all players named sachin from the players table.
Explain the difference between triggers and constraints?
Which function is used to return remainder in a division operator in sql?
what is msql? : Sql dba
How to download oracle sql developer?
where are cookies actually stored on the hard disk? : Sql dba
Which join is like inner join?
Can a varchar be a primary key?
Define sql delete statement.
Is sql better than access?
What is a data definition language?