Bisa dicoba query berikut ini:
SELECT SUM(DECODE(HARI,'SUN',TO_CHAR(TGL,'DD'))) MIN,
SUM(DECODE(HARI,'MON',TO_CHAR(TGL,'DD'))) SEN,
SUM(DECODE(HARI,'TUE',TO_CHAR(TGL,'DD'))) SEL,
SUM(DECODE(HARI,'WED',TO_CHAR(TGL,'DD'))) RAB,
SUM(DECODE(HARI,'THU',TO_CHAR(TGL,'DD'))) KAM,
SUM(DECODE(HARI,'FRI',TO_CHAR(TGL,'DD'))) JUM,
SUM(DECODE(HARI,'SAT',TO_CHAR(TGL,'DD'))) SAB
FROM
(
SELECT (LAST_DAY(LAST_DAY(TO_DATE('AUG2006','MONYYYY')) - 32) + 1)+rownum-1
TGL,
TO_CHAR(((LAST_DAY(LAST_DAY(TO_DATE('AUG2006','MONYYYY')) - 32) +
1)+rownum-1),'DY') HARI,
TO_CHAR(((LAST_DAY(LAST_DAY(TO_DATE('AUG2006','MONYYYY')) - 32) +
1)+rownum-1),'WW') MINGGU
FROM ALL_OBJECTS
WHERE ((LAST_DAY(LAST_DAY(TO_DATE('AUG2006','MONYYYY')) - 32) +
1)+rownum-1)
BETWEEN (LAST_DAY(LAST_DAY(TO_DATE('AUG2006','MONYYYY')) - 32) + 1)
AND LAST_DAY(TO_DATE('AUG2006','MONYYYY'))
)
GROUP BY MINGGU;
MIN SEN SEL RAB KAM JUM SAB
---------- ---------- ---------- ---------- ---------- ---------- ----------
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
Jika ingin mendapatkan bulan yang lain, ganti bagian AUG2006 dengan bulan
yang dikehendaki, misalnya
untuk bulan September 2006, ganti dengan SEP2006, dst, atau untuk lebih
mudahnya masukkan ke parameter
agar tidak mengetikkan bulan dan tahun secara berulang-ulang.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: "fata hudaya" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, August 08, 2006 12:17 PM
Subject: [indo-oracle] Query Calender di SQL*Plus?
> Dear Master,
>
> Saya mo tanya, gimana ya cara meng-query Kalender di SQL*Plus ? Dengan
> menggunakan parameter bulan apa yang akan kita tampilkan atau semua bulan
> dalam 1 tahun.
> c/o :
>
> Agustus - 2006
> MIN SEN SEL RAB KAM JUM SAB
> 1 2 3 4
> 5
> 6 7 8 9 10 11
> 12
> 13 14 15 16 17 18 19
> 20 21 22 23 24 25 26
> 27 28 29 30 31
>
> Mohon pencerahannya...
>
> Many Thanks & Best Regard,
>
> Fata Hudaya,
> +628567143271
> [EMAIL PROTECTED]
>
>
>
> [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.blogspot.com
> Mirror: http://indooracle.wordpress.com
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006
>
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
