What is difference between function and procedure?
Answer Posted / sudipta kumar dhal
1.Function is a subprogram that returns a value.
2.Procedure is a subprogram that performs a specific action.
3. Function can return only one value but procedure can return
more than one, or may not return any value.
4. Function can be called from sql statements where as
procedure cannot be called from the sql statements.
5. We can use functions in select statement but we can not use
procedure in select
6.You can have DML(insert,update, delete) statements in a
function.
7.You can have DDL(create,alter,drop) statements in a
procedure.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris
What are the types of properties that quick test learns while recording?
I used child objects to get the no of weblist present in the weblist.now i need to select the items present in each weblist ?How to do so
action contains public and private functions but do we resuable that action or not..If it is reusable How..plz tell me the ans
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
Analyzing the checpoint results?
Explain about the quicktest professional (qtp) automation object model?
how do i know how to use tools
What is the difference between shared and local object repository?
Hi this is chandra if any one have Navigation of LAB QTP, I want Navigation of those tools, if any one have the and know the Navigation each and every part of the QTP, plz send me my mail naruboinac@yahoo. com,naruboinas@ gmail.com
X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?
How many types of object repository in qtp?
What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?
give me an example where u used good judgement and logic in solving a problem
What are the technics follow in writing VB script?