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
Why oracle forms required?
What is a canvas in oracle forms?
How can we expand Parameter Form Canvas on Reports 6i?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
Can we invoke one form from another in a multi-forms application?
how to send file attachment from oracle forms
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
what are the new features introduced in oracle form services in 11g release 2?
What is a user exit program in oracle reports?
what is difference between group above and group left report
What is a matrix report and how many minimum groups are required to prepare the same?
from where do u receive the information to develop report
what are the oracle forms services components include?
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