What are main difference between Stored Procedure and
Functions.
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
Can select statements be used on views in oracle?
How does oracle handle read consistency?
Explain the use of tables option in exp command.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What happens to the data files if a tablespace is dropped?
What happens if you use a wrong connect identifier?
State and explain the different types of data models?
What is oracle server autotrace in oracle?
What is transport network substrate (tns) in oracle?
How to use subqueries with the in operator using oracle?
List out the types of joins.
Explain what are the uses of rollback segment?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to check your oracle database 10g xe installation?
Can a formula column be obtained through a select statement ?