What is difference between function and procedure?

Answer Posted / nafaji

1. Function can return only one value but procedure can return more than one, or may not return any value.

2. Function can be called from sql statements where as procedure cannot be called from the sql statements.

3. We can use functions in select statement but we can not use procedure in select statement.

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use the regular expression for the below code-- swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:56" There is a tree view window of the folder's ie Medication- >Pharmacy(sub folder)with 56 as count of records...The records can be different or if no records present in the specific folder..then it show "Paharmacy:-no records".Whe i record at the first time .....and try to rerun the same script with different records count say "pharmacy:800"..qtp is not regnizing it...therefore i want to user regular expression..but donot now how to use it and where to use...i have tried.... swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:\*"..but it s of no use..plz help..me

2561


what function you write to do database testing with the help of qtp?

1450


Thanks....But can u tell me how i use the QTP for GIS with one Example...

1536


How to use checkpoints in qtp ?

666


Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

1784






What are the types of object repository in qtp?

659


suppose i login into gmail page after that i read all the messages (say 10 messages) i have to send (SAVE) the messages in Html,notepad and i have to replay(Compose) send the messages please give me the code and give mail id so that i can clear my question

1577


To which environments does quicktest professional (qtp) supports?

674


How should I click on the right click menu objects When I trying to add the object properties to the OR.It is showing only Window(Window).Not all the objects of the window. Also while recording I found No script. How to solve this>.

1628


when to start the automation?

1546


How to call a test from another test?

782


What is ‘object spy’ and what is the function of object spy in qtp?

661


What is quicktest professional (qtp window?

691


banking domain description for software tester for interview

3541


Explain qtp(quick test professional)?

659