how report can be generated if we have the database designed
in oracle 10g?
- 1 Answers
- 3921 Views
- I also Faced
- E-Mail Answers
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 the different styles of actvation of ole Objects?
i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com
Can a root window be made modal?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
a text item is there what r the different types of triggers associated with it
What are the Coordination Properties in a Master-Detail relationship?
What are parameters?
What is a Trigger ?
What is the main difference between Reports 2.0 & Reports 2.5?
What are the built-ins that are used to Attach an LOV programmatically to an item?
What do you understand by lov?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? If yes,how?
Oracle General 
