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 are Navigational Triggers?
Can a repeating frame be careated without a data group as a base?
what u write in Ctl file
What are three panes that appear in the run time pl/sql interpreter?
What is trigger associated with the timer?
I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent
what is procedure like symbols of bind and lexical
how to load data into base tables
What are the type of triggers available in Oracle Reports ?
3 Answers Convergys, IBM, KPIT, Oracle, TCS,
What is the difference between keystartup and pre-form ?
why the Ctl file u put only in bin folder why not in other folder
what is difference between group above and group left report