Answer Posted / su

By using sql*plus environment.
we can specify the column width , through following
sql> COL empno FORMAT 999999
sql>COL ENAME FORMAT A30

sql>SELECT empno as "Employee Number",
ename as 'Employee Name"
FROM emp;

we can also use TTITLE, BTITLE etc
:)

Explain the various types of oracle report?

1077

---

Name the different triggers supported by oracle reports and their firing order.

1092

---

what are bind variables?

1092

---

what is tripstop report?

1839

---

if u want to delete all these detail block etc what will happen in form

1989

---

where do u put the report file

2098

---

In what situation u create the BPA.

2211

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1025

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1698

---

what are the oracle forms services components include?

1032

---

What is the difference between flex mode and confined mode?

1055

---

How can we generate report output in excel format?

997

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1898

---

How to create Drill down report?

2134

---

Explain master-detail relationship with some examples.

1009

---