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
how to prepared for first for the first interview?
what is clean sweep?
Hi,All How to create a link in excel sheet using qtp
can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process
Plz Explain AUTOMATION REFERENCE MODEL?
how to explain a claims and insurance project?
When Recovery scenario actually starts while testing the application?
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
How u will do versioning in QTP?
How to check feasibility of the appliction?in automation testing?
Explain the terms test and business component?
what type of automation is follwed in the project?
What is the difference between a Function and Action in QTP?
How to find the length of the string in qtp?
Explain quicktest professional (qtp) testing process?