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

can we use look up type instead of a pofile option?or valueset?is it possible how?

2201

---

Do you know what is applysys in oracle application database schema, what is apps?

1168

---

How do you register report in oracle apps?

1081

---

Tell me how to debug the report?

1112

---

How can we import the data into a database using sql * loader?

1173

---

What is a value set? List its various types.

1080

---

In oracle application how do you debug or trace errors?

1092

---

What is sca and how is it useful?

1106

---

What is count(*) from po_vendors(any table)?

1074

---

Tell me where we find the status of order information?

1130

---

In hierarchical structure of a database? we have write query from where we should start?

2224

---

tell my any difficult situtation you solved in your experience in your company?

2309

---

what is pay run id ?

2182

---

What are the Standard Reports and Forms in HRMS?

2288

---

what are the prerequisites for costing transactions?

3126

---