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
what are bind variables?
How can we generate report output in excel format?
Explain the different levels at which oracle form services interact.
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
a text item is there what r the different types of triggers associated with it
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What do you understand by lov and how can it be used?
hiding item in report how like that properly,thats manually but at runtime i want to do
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
did u p prepared complex report
how to send file attachment from oracle forms
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 the difference between BPA AND Contract What are documents and test cases u followed
Is it possible to have multiple layouts in a report?