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;
Begin
For emp_record in emp_cursor loop
Print (emp_record.empno);
Print (emp_record.ename);
Print (emp_record.sal);
End loop;
End;
Output :
var empx number;
Begin
:empx := ?1234?;
End;
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,






Categories
  • 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)