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

Is it possible to execute a dynamic sql from forms?

0 Answers  


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

1 Answers  


what are the different objects that you cannot copy or reference in object groups?

1 Answers  


What is the basic data structure that is required for creating an LOV?

1 Answers  


can i use lexical variable in formula column

1 Answers  






hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

0 Answers   IBM,


what are the new features introduced in oracle form services in 11g release 2?

0 Answers  


What are the types of Pop-up window ?

1 Answers  


What buil-in routines are used to display editor dynamicaly?

1 Answers  


What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

1 Answers  


Use the Add_group_row procedure to add a row to a static record group 1. true or false?

2 Answers  


What is the usage of the confine mode in Layout Editor ?

2 Answers   Convergys,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)