Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 5 Answers
- 10062 Views
- E Logic, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santhaebenezar
function will return a value where as
procedure may or maynot return a value
| Is This Answer Correct ? | 6 Yes | 1 No |
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 |
Answer / rambhupal reddy
function can use sql queries
procedure are not used in sql queries
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / parvathy
Procedure is written in natural language........
whereas function is a block of codes......
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / karthick.r
procedure may or may not return values but function should
return values
| Is This Answer Correct ? | 0 Yes | 1 No |
tell me the scenarios of the independent in reports
How to find which company will be conducted Oracle appa interview? Plz help me
Where we can write a PL/SQL code in report triggers?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
why r u transer the data base tables to flat file and what is use
How to insert data into two tables using single control file?
what is global tempory table?
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
Difference between Bind and Lexical parameters?
How do u customize the Reports?
Can you explain the difference between architecture followed in 10g & 11g?
what is difference between procedure and function
Oracle Apps Technical 
