Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a PROCEDURE & FUNCTION ?
- 6 Answers
- 12077 Views
- Satyam, I also Faced
- E-Mail Answers
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 are packages in pl sql and also explain its advantages?
Why self join is used in sql?
Are stored procedures faster than queries?
How bulk collect improves performance?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How to get unique records from a table?
Is nosql faster than sql?
Explain the uses of a database trigger?
How does sql profiler work?
What is percent sign in sql?
Is t sql a programming language?
What is the advantage of index in sql?
Is sql free?
Does truncate release storage space?
what are the differences among rownum, rank and dense_rank? : Sql dba
