Saya mo tanya tentang report matrix, ada query spt di bawah ini :
SELECT *
FROM (SELECT job,
sum(decode(deptno,10,sal)) DEPT10,
sum(decode(deptno,20,sal)) DEPT20,
sum(decode(deptno,30,sal)) DEPT30,
sum(decode(deptno,40,sal)) DEPT40
FROM scott.emp
GROUP BY job)
ORDER BY 1;
dan outputnya a/ :
JOB DEPT10 DEPT20 DEPT30 DEPT40
--------- ---------- ---------- ---------- ----------
ANALYST 6000
CLERK 1300 1900 950
MANAGER 2450 2975 4850
PRESIDENT 5000
SALESMAN 5600
konsepnya a/ matrix. Yang saya tanyakan a/ : Apabila kita ingin membuat report
matrix, tapi yang kita gunakan a/ report tabular apakah akan mempengaruhi konsep dari report matrix itu sendiri.???
kalo temen2 punya tutorial / link oracle report,khususnya report matrix mohon di share... OK !
Terimakasih atas pencerahannya.
Fata Hudaya,
+62567143271
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---------------------------------
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS
| Membership database software | Database mortgage software | Pda database software |
| Database management software | Oracle database administration | Oracle database management |
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
