Answer Posted / sudipta santra

1. In Report's Data model part, click on Placeholder column
from toolbox, then a placeholder column will be created with
default name CP_1 as like if u want u can change the name.
2. Go to the PL/SQL by right clicking on the newly created
placeholder column in data model.
function CP_1Formula return char
begin
return null;
end;
3. Click on Formula column from toolbox, then a formula
column will be created with the default name CF_1/CF_2 as
like that, if u want u can change it's name.
4. Go to the PL/SQL by right clicking on the newly created
formula column in data model.
function CF_1Formula return number
begin
if :stock<10 then
:CP_1:= 'Too less stock';
elsif :stock<50 and :stock>10 then
:CP_1:= 'Average stock';
else
:CP_1:= 'Good stock';
end if;
return 1;
end;

Note: Here the placeholder column is used with the null
carrying result but when the formula be used then the
placeholder will get value and will carry this in report.
And also we can use this anywhere in report as according
application requiremnt needs.

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2246

---

Why oracle forms required?

984

---

did u received a single file or multiple files

1982

---

difference between global n context sensitive segments?

2634

---

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1941

---

Explain how can you use the same lov for 2 columns?

1088

---

What is a matrix report and how many minimum groups are required to prepare the same?

1072

---

Explain the various types of oracle report?

1026

---

what is tripstop report?

1775

---

What do you understand by oracle forms?

978

---

a text item is there what r the different types of triggers associated with it

1953

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1173

---

how report can be generated if we have the database designed in oracle 10g?

1843

---

What do you understand by lov and how can it be used?

1026

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1245

---