What is difference between a PROCEDURE & FUNCTION ?
Answer Posted / pankaj mehra
Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is a primary key? Explain
What is the maximum database size for sql express?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are %type and %rowtype for?
which types of join is used in sql widely? : Sql dba
What is a sql select statement?
Is sqlite good enough for production?
How do sql triggers work?
Is postgresql a nosql database?
What is the reports view in oracle sql developer?
What is the difference between rename and alias?
What is pessimistic concurrency control? : Transact sql
Can a view be mutating? If yes, then how?
What are basic techniques of indexing?
What are types of joins?