Answer / oracleapps_learner

The Report builder Built in package know as SRW Package
This package extends reports ,Control report execution,
output message at runtime, Initialize layout fields, Perform
DDL statements used to create or Drop temporary table,
Call User Exist, to format width of the columns, to page
break the column, to set the colors
Ex: SRW.DO_SQL, It?s like DDL command, we can create table,
views , etc.,
SRW.SET_FIELD_NUM
SRW. SET_FILED_CHAR
SRW. SET FILED _DATE

in procedure how to return a value

3 Answers  

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

what is meant by bind parameter?

2 Answers   Satyam,

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

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

0 Answers   IBM,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 Answers  

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

How to move the one file from one instance to another instance? And your scripts also?

0 Answers  

---

Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,

---

what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,

---