Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26731 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / hemanth
1) functions are used for computations where as procedures
can be used for performing business logic
2) functions MUST return a value, procedures need not be.
3) you can have DML(insert, update, delete) statements in a
function. But, you cannot call such a function in a SQL query..
eg: suppose, if u have a function that is updating a table..
you can't call that function in any sql query.
- select myFunction(field) from sometable;
will throw error.
4)We can call a function from a procedure, but it is not
possible to call a procedure from a function
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is the difference between $oracle_base and $oracle_home?
How to invoke the original export import utilities?
How do I know if oracle is installed on windows?
What is difference between sid and service name in oracle?
How would you go about verifying the network name that the local_listener is currently using?
How to get the Installed Oracle Version Information ?
How to drop an index in oracle?
Explain about the analyze command in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is truncate oracle?
Why does for update in oracle 8 cause an ora-01002 error?
defination of bitmap index
Why does Oracle not permit the use of PCTUSED with indexes?
Is oracle a relational database?
What do you mean by merge in oracle and how can we merge two tables?
