What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 24263 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / abapdeveloper09
Adding to S. Elaiyaraja's responnse:
- Functions should have RETURN clause
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the use of inctype option in exp command.
Give the advantages and disadvantages of clusters.
List out the difference between commit, rollback, and savepoint?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is hash cluster in oracle?
What is the parameter mode that can be passed to a procedure?
what is port in oracle? how is it related to database application.
How many memory layers are in the oracle shared pool?
What is Segment Advisor in Oracle?
What is the usage of control file in oracle?
What are the different types of modules in oracle forms?
In the oracle version 9.3.0.5.0, what does each number shows?
How to connect ms access to oracle servers?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to define an oracle sub procedure?
