What is difference between a PROCEDURE & FUNCTION ?
- 6 Answers
- 10729 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 is the example of procedure?
How do I view output in sql developer?
How to run pl/sql statements in sql*plus?
How to avoid using cursors?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is sql keyword?
How do I run a program in pl sql?
What is #table in sql?
What is the primary use of normalization?
What is plpgsql language?
What are the different ddl commands in sql?
How many sql core licenses do I need?
What is pl sql architecture?
what are rollup and cube in t-sql? : Transact sql
Can you load data into multiple tables at once? : aql loader
