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


Please Help Members By Posting Answers For Below Questions

Can select statements be used on views in oracle?

751


How does oracle handle read consistency?

861


Explain the use of tables option in exp command.

800


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1638


What happens to the data files if a tablespace is dropped?

781






What happens if you use a wrong connect identifier?

679


State and explain the different types of data models?

685


What is oracle server autotrace in oracle?

833


What is transport network substrate (tns) in oracle?

769


How to use subqueries with the in operator using oracle?

798


List out the types of joins.

822


Explain what are the uses of rollback segment?

749


In what script is snap$ created? In what script is the scott/tiger schema created?

2437


How to check your oracle database 10g xe installation?

729


Can a formula column be obtained through a select statement ?

2069