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
How does sql developer connect to oracle database?
What are the sql aggregate functions?
How to install oracle sql developer?
How to get each name only once from an employee table?
Does pdo prevent sql injection?
How many disk partitions should I have?
What is example of database?
what are the 'mysql' command line arguments? : Sql dba
What are different types of functions in sql?
Which software is used for pl sql programming?
What are the possible values for the boolean data field?
What is nested table in pl sql?
Is pl sql different from sql?
How do I quit sql?
What is implicit cursor in pl sql?