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 is a user exit program in oracle reports?
Name the different triggers supported by oracle reports and their firing order.
did u received a single file or multiple files
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
hiding item in report how like that properly,thats manually but at runtime i want to do
What do you understand by oracle forms and why are they required?
What is a matrix report and how many minimum groups are required to prepare the same?
What is the difference between bind and lexical parameter?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
How to create Drill down report?
What is responsibility and how u attach How to create user and how u attach with responsibility.
i am writing a query select EmpNo from Emp how can i call in after parameter form
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
what are bind variables?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?