Answer / praveen

%TYPE,
%ROWTYPE

Answer / mohan kumar

SQL%ISOPEN
SQL%ROWCOUNT
SQL%NOTFOUND
SQL%CLOSED

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

what is lexical parameter?

3 Answers   TCS,

---

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

---

what is the difference between procedure and function

3 Answers   Wipro,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers   Tech Mahindra,

---

How is choreography different from orchestration?

0 Answers  

---

i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,

---

What are the requests groups?

3 Answers  

---

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---