What is procedure?

Answers were Sorted based on User's Feedback

What is procedure?..

Answer / kiran kumar

---- is a named pl/sql block to perform a specific task.
---- A procedure may have DML statements.
---- It may or may not return a value.
---- Procedure can return more than one value.

Example for procedure
1)To accept the year as a parameter and list emp belong to
the year?
Create or replace
Procedure empy(y number) is
Cursor emp_cursor is
Select * from emp where to_char(hiredate,?yyyy?)=?y?;
Emp_record emp%rowtype;
For emp_record in emp_cursor loop
Print (emp_record.empno);
Print (emp_record.ename);
Print (emp_record.sal);
End loop;
Output :
var empx number;
:empx := ?1234?;
Exec empy(:empx);
Print empy;

Is This Answer Correct ?    1 Yes 0 No

What is procedure?..

Answer / nidhi

Procedure consist of set of the PL/SQL statments that are
grouped togather as a unit to solve a specific problem or
perform set of related tasks.
-->May or may not return the value.
-->can not use in teh sql queries because returns more than
one value.

Is This Answer Correct ?    0 Yes 0 No

What is procedure?..

Answer / chandrasekhar

procedure is subprogram in pl/sql that contains a set of
SQL and PL/SQL statements.Subprograms once we executed can
be used in any no.of applications

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

Except the SRS window in which we can submit the concurrent program.

5 Answers   TCS, IBM,

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,

Which is the best website to learn Oracle Apps?

2 Answers  

Exception Handilings?

1 Answers  

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

0 Answers  

when we run payment batch what are the 3 concurrent programs?

1 Answers   Wipro, Genpact,

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Oracle, Deloitte,

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

How to print multi currency,multi language in xml?

1 Answers  

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,

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