what is difference between procedure and function




Answers were Sorted based on User's Feedback



what is difference between procedure and function..

Answer / santhaebenezar

function will return a value where as
procedure may or maynot return a value

Is This Answer Correct ?    6 Yes 1 No

what is difference between procedure and function..

Answer / venky

Function can be use in SQL queries
Procedure can't be used in SQL queries

Function call by an Expression
Procedure call by Statement

The Main diff is DML
Through procedures we can insert,update,delete data from
Table
Through Functions we can't

Is This Answer Correct ?    5 Yes 4 No

what is difference between procedure and function..

Answer / rambhupal reddy

function can use sql queries
procedure are not used in sql queries

Is This Answer Correct ?    1 Yes 0 No




what is difference between procedure and function..

Answer / parvathy

Procedure is written in natural language........
whereas function is a block of codes......

Is This Answer Correct ?    1 Yes 2 No

what is difference between procedure and function..

Answer / karthick.r

procedure may or may not return values but function should
return values

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Oracle Apps Technical Interview Questions

Difference between Bind and Lexical parameters?

3 Answers  


How can a process be deployed in soa?

0 Answers  


What is request group

4 Answers   Accenture,


IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  


What are do's and dont's of Interface?

0 Answers  






what is difference between d2k report and oracle apps report

10 Answers   Wipro, Seven Hills,


What are the requests groups?

3 Answers  


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,


Are you familiar with internet architecture of oracle apps 11i?

0 Answers  


wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,


what are the different transaction clauses in AR?

0 Answers   BirlaSoft,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)