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

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

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2274


What is an SQL FORMS ?

2310


suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1598


In what situation u create the BPA.

1771


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

1856






What do you understand by oracle forms and why are they required?

551


Is it possible to execute a dynamic sql from forms?

596


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1530


What is a canvas in oracle forms?

586


what are the oracle forms services components include?

555


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

1565


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

1457


What do you understand by oracle forms?

585


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

1549


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

1473