how report can be generated if we have the database designed
in oracle 10g?
Answer / 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 |
How do you display console on a window ?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
what are bind variables?
Can you have more than one content canvas view attached with a window?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
explain tkprof?
How do you reference a Parameter?
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT. WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES TOTAL SHOULD BE DISPLAYED
What is Post-Block?
What are the differrent types of windows?