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
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
What is an SQL FORMS ?
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
In what situation u create the BPA.
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What do you understand by oracle forms and why are they required?
Is it possible to execute a dynamic sql from forms?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What is a canvas in oracle forms?
what are the oracle forms services components include?
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
how report can be generated if we have the database designed in oracle 10g?
What do you understand by oracle forms?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
if u want to delete all these detail block etc what will happen in form