Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between function and procedure?
- 41 Answers
- 109211 Views
- HCL, IBM, iGate, Infosys, TCS, Veritas, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sardar tariq
A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.
-Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter.
-Function can be called from SQL statements where as procedure can not be called from the sql statements.
-Functions are normally used for computations where as procedures are normally used for executing business logic.
-You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query.
-nction returns 1 value only. Procedure can return multiple values (max 1024)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are output values and why they are used ?
Does quicktest professional (qtp) is unicode compatible?
How you can find length of array in qtp?
What is clean sweep?
How does quicktest professional identifies the object in the application?
What is action split and the purpose of using this in qtp?
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 could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)
how to i add the values using the check points property?( i.e valid data(for valid data it's giving the footer message:value is added) and for invalid data: special chars, spaces,Duplicates and null values (in my page when ever we enter special chars, spaces and null values, it's giving the proper warning message and for Duplicates it's giving the footer message:"value already exists)?
How qtp recognizes the object?
What is business process testing(bpt) in qtp?
Did QTP prove efficient for your project? Yes or No, explain?
Does Low-level recording capture mouse movements?
What is the purpose of loading qtp add-ins?
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya
