Differentiate between function and procedure in oracle.
- 1 Answers
- 1189 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are nested tables?
When system tablespace is created?
Please explain compound trigger in oracle?
How many data types are supported?
what are Triggers?
What is oracle data type?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What are the factors causing the reparsing of SQL statements in SGA?
How to return top 5 rows in oracle?
create one table to capture an employee details with a primary key.
Is oracle the best database?
Why do we need integrity constraints in a database?
Oracle General 
