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

what is item status? name the related table.

1 Answers   Scan Steel,

why do we validate the records while developing interface?

3 Answers   TCS,

Can you have two stored functions with in the same name?

3 Answers  

What are documents and test cases u followed.

2 Answers   Accenture,

explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,

what are the important table names in purchasing?

3 Answers   TCS,

Define multi org structure with example(take any businees).

1 Answers   Wipro, Oracle,

what are the tables of auto invoice.

2 Answers  

what are the different calculation columns available in reports?

1 Answers  

what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,

What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Asian Paints, Tech Mahindra, Accenture, Inbound Solutions,

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,

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