What is the between Function and Procedure?

Answer Posted / guest

fun returns values
proc may or may not return values

fun always contain a return statement
proc not.

fun can be used in select queries
proc can not be.

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between call_form, new_form and open_form?

965


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1061


What is the difference between flex mode and confined mode?

738


What is the difference between bind and lexical parameter?

790


How can we expand Parameter Form Canvas on Reports 6i?

2171


if u want to delete all these detail block etc what will happen in form

1734


what is a package n what r the packages availbla in report

1860


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1904


Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1909


Explain how can you use the same lov for 2 columns?

878


Explain the various types of oracle report?

824


what exactly u write in when_new_form_instance

3191


what are the oracle forms services components include?

762


Explain the different levels at which oracle form services interact.

801


What do we mean by record group in oracle forms?

835