Answer Posted / vasu

Whenever you need to change the query value at runtime then
create a parameter which reads the value during run time.
In this scenario which you are creating the parameters are
known as user parameters.
eg: create a sql query as below:
select * from emp where deptno=:p_deptno

Then system creates a parameter named p_deptno. This bind
parameter is a user parameter.

Run the report, During run time system expect the deptno
value from the user.

I hope you understood.

List the types of flexfield?

989

---

can we get profile values in report without using user exists is it possible how?

2825

---

Plz anybody send me Technical specification for AP Interface

2503

---

What do you understand by soa and what are the benefits of using this architecture?

1026

---

How do you register report in oracle apps?

1030

---

What is a flexfield? List out its types.

1109

---

Tell me how to debug the report?

1065

---

what are the balancing segments in AR?

2041

---

how to print multi lay outs,muti currency,muti language in xml publisher

12151

---

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

2171

---

q)what are the validations in sql*loader

2329

---

How to create a purchase order without a requisition?

1123

---

What do you understand by a set of books?

1040

---

what is global tempory table?

7125

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2070

---