what is difference between procedure and function
Answer Posted / aditi yadav
in addition to above answers -
1. Functions can be called inside procedure but procedure cannot be called inside functons.
2. Functions compiled every time when we call them whereas procedure compiles only once & can be called again and again without being compiled.
3. we can user functions in select statement but cannot use procedure.
4. Inside function we cannot user DML commands but inside procedures we can use DML commands.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the advantages of using stored procedures? : Sql dba
What is relationship? How many types of relationship are there?
What does a pl/sql package consist of?
what is an alias command? : Sql dba
What is dense_rank in sql?
What is sql and how does it work?
What are different types of tables in sql?
What is difference between pls_integer and integer?
Do we need to create index on primary key?
How do I find duplicates in two columns?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What are different functions in sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Why partition by is used in sql?
What is equi join in sql?