Answer / sanjoy mukhopadhyay, cesc ltd,

PL/SQL tables are PL/SQL’s way of providing arrays. Arrays
are like temporary tables in memory and thus are processed
very quickly.

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.

2 Answers  

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---

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

3 Answers   Accenture,

---

Matrix Report: Simple, Group above, Nested

1 Answers  

---

What is Formula Column?

4 Answers  

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

what are centralized and decentralized level of control of item attributes?

2 Answers   Scan Steel,

---

What are do's and dont's of Interface?

0 Answers  

---

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,

---

in procedure how to return a value

4 Answers  

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---

What is sca and how is it useful?

0 Answers  

---