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
:)

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

1945

---

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

2246

---

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

1087

---

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

1636

---

how do u place it in required folder

1873

---

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2950

---

difference between global n context sensitive segments?

2634

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2333

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1939

---

why the Ctl file u put only in bin folder why not in other folder

2003

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1861

---

What do you understand by oracle forms?

978

---

what are the new features introduced in oracle form services in 11g release 2?

984

---

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

1938

---

if some data is not transfered where it will get stored

1890

---