how report can be generated if we have the database designed
in oracle 10g?



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

Post New Answer

More Oracle Forms Reports Interview Questions

What is relation between the window and canvas views?

2 Answers   ABC,


i created a parameter list in reports. how to restrict that parameter list with parameters

1 Answers   iFlex,


how to send sms to mobile phone from oracle forms.

1 Answers   HP, Tech Mahindra,


how can create the lexical parameter after the select class?

1 Answers   Oracle,


What are Most Common types of Complex master-detail relationships?

1 Answers  


if some data is not transfered where it will get stored

0 Answers  


How to call a report from Forms?

5 Answers  


What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?

1 Answers  


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 ....

4 Answers  


difference between place holder and formula column

3 Answers   Cognizant, IBM, Microsoft,


What is a window?

2 Answers  


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

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)