Differentiate between function and procedure in oracle.
- 1 Answers
- 1190 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mitesh Shandilaya
In Oracle, both functions and procedures are used to encapsulate code and are stored in the database. The main difference lies in their return values and usage: n 1. Function - returns a value after executing the code block. It can be used as an expression or part of another statement. n 2. Procedure - does not return any value, but performs actions based on its code block.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
How to start an oracle instance?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
