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;

What is sca and how is it useful?

1129

---

what is pay run id ?

2196

---

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

1179

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2048

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2266

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1123

---

What is oracle soa suite and what are its different components?

1219

---

Do you know what are user profiles in apps. Any examples you can give?

1097

---

List the various types of value set.

1082

---

What do you understand by concurrent programs?

1102

---

What does appl_top directory contain?

1123

---

where to define interorganization transaction charges and what are the different options?

2421

---

What are file in oracle.

2238

---

Do you know where we can check the status of po?

1290

---

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

2247

---