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 |
What is relation between the window and canvas views?
i created a parameter list in reports. how to restrict that parameter list with parameters
how to send sms to mobile phone from oracle forms.
how can create the lexical parameter after the select class?
What are Most Common types of Complex master-detail relationships?
if some data is not transfered where it will get stored
How to call a report from Forms?
What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?
I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
What is a window?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory