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 do we mean by record group in oracle forms?

603


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

1948


Is it possible to have multiple layouts in a report?

566


why the Ctl file u put only in bin folder why not in other folder

1590


Explain how one can iterate through items and records in a specified block?

539






How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1634


what is difference between group above and group left report

3193


What is an SQL FORMS ?

2304


Is it possible to execute a dynamic sql from forms?

591


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.

1689


What is a user exit program in oracle reports?

565


how do u compile a form i.e .fmb file in Unix or in dos

4014


Explain master-detail relationship with some examples.

575


In what situation u create the BPA.

1771


List the different types of columns in oracle reports.

563