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

what is difference between procedure and function

5 Answers   E Logic,


Registering parametric report?

1 Answers  


HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,


where we find the status of order information.

2 Answers  


Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,


What is Value Set?

2 Answers   Accenture,


Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,


After deploying like forms,reports into server how we connect this forms,reports to web?

1 Answers   IBM,


what is the difference between procedure and function

3 Answers   Wipro,


can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,


Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,


While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • 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)