What is the between Function and Procedure?

Answers were Sorted based on User's Feedback

What is the between Function and Procedure? ..

Answer / 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

What is the between Function and Procedure? ..

Answer / honnaiah

Function computes results.
Procedure performes an action

Is This Answer Correct ?    1 Yes 0 No

What is the between Function and Procedure? ..

Answer / venkat

Function has to return a value where as a procedure may or may not return a value

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

LOV can best describe a) window b)modal c)list d) none of these d)

5 Answers   ESS,

how can create the lexical parameter after the select class?

1 Answers   Oracle,

what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item

2 Answers  

What are the different file extensions that are created by oracle reports?

1 Answers  

At what point of report execution is the before Report trigger fired?

1 Answers  

List the different types of columns in oracle reports.

0 Answers  

how will the report recognize the parameter

1 Answers  

What is an SQL FORMS ?

0 Answers   Verizon,

What are display items?

3 Answers  


1 Answers   Jaguar, TCS,

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

0 Answers  

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com

5 Answers  

  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)