Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26896 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 null value in oracle?
How to use null as conditions in oracle?
How to estimate disk space needed for an export job?
Does oracle partitioning improve performance?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Explain the use of grant option in exp command.
What's dateware house and what's clustor with practicle example
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What do you mean by a deadlock?
What is the usage of merge statement?
What is a connect identifier?
What is dynamic proxy?
Can a formula column referred to columns in higher group ?
What is an oracle function?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
