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
I want to write some certification courses, so friends could you guide me? which certification is best and how to write exam and what tutorials need to be studied,what to do first, I am working on automation tool QTP 9.2
if mandatory and Assitive propertys are shows same how will u write skript in QTP window
How QA specialist can identify when programmatic descriptions are useful?
Why is action split used by qtp?
could any help me please, how to work on visual foxpro application using UFT
Explain actions in qtp ?
WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT
What is test object model in quicktest professional?
How to use descriptive programming?
What is active screen?
Why we load add-ins in qtp?
What is the meaning Work bench?
What is object spy in quicktest professional?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.
How would you directly trigger javascript in a test?