Interested to Buy Any Domain ? << Click Here >> for more details...
what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
- 3 Answers
- 7983 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / rajesh venati
1. Procedures are used to perform a particular task.
2. Procedures may or may not return a value, if u want
return a value though the OUT parameter it is possible. It
doesn't contain any RETURN key word.
3. Procedures are not valid in SELECT statement.
1. Functions are used for computation purpose.
2. Function must and should be return a value.
3. We can execute function in a SELECT statement.
-- If u use OUT or IN OUT parameters or perform any DML
operations on functions it is not valid in SELECT statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is union?
What is the use of non clustered index?
Can you have a foreign key without a primary key?
What steps server process has to take to execute an update statement?
What are the most important ddl statements in sql?
What is sql profiling in oracle?
Why is a primary key important?
What makes a good primary key?
i have some prob lem to tell me about my self in interview first round ...
What does seeding a database mean?
What is anonymous block in sql?
What is pl sql code?
What is the trigger in sql?
How is sql used in oracle?
What is delete command in sql?
