| | Function must return value whereas procedure does not |
| | Function can be used in SQL statement whereas procedure can not. Function can be used in SQL statement, if it do not perform any DML operation |
| | USER_FUNCTIONS data definition stores function details. USER_PROCEDURES data definition stores procedure details |
difference between procedure and function
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment