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
How can we generate report output in excel format?
Explain how one can iterate through items and records in a specified block?
what is the difference between call_form, new_form and open_form?
from where do u receive the information to develop report
What are the various configuration files that are used by oracle forms?
what are bind variables?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What is an oracle report? List its various types.
Can we invoke one form from another in a multi-forms application?
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 the difference between BPA AND Contract What are documents and test cases u followed
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
how do u place it in required folder
did u p prepared complex report
Explain the different levels at which oracle form services interact.