Archive for September, 2008

arti bacaan sholat (3)

September 13, 2008 at 4:38 pm · Filed under attention plz!, malam minggu, sinau

RUKU’

SUBHAANA RABBIYAL ‘ADHIIMII WA BI HAMDIH
Maha suci Tuhanku yang maha besar dan dengan segala puji-pujiannya

I’TIDAL

SAMI’ALLAAHU LI MAN HAMIDAH
Allah mendengar orang yang memuji-Nya

RABBANAA LAKAL-HAMDU MIL’US-SAMAAWAATI WA MIL-UL-ARDHI WA MIL’U MAA SYI’TA MIN SYAI’IN BA’DU
Ya Allah tuhan kami, bagi-Mu segala puji, sepenuh langit dan bumi, dan sepenuh barang yang Kau kehendaki sesudah itu.

SUJUD

SUBHAANA RABBIYAL-A’LAA WA BI HAMDIH
Maha suci tuhan yang maha tinggi serta memujilah aku kepada-Nya.

DUDUK ANTARA DUA SUJUD

RABBIGHFIRLII WARHAMNII WAJBURNII WARFA’NII WARZUQNII WAHDINII WA ‘AAFINI WA’FU ‘ANNII
Ya Allah, ampunilah dosaku, belas kasihanilah aku dan cukupkanlah segala kekuranganku dan angkatlah derajatku dan berlah rezeki kepadaku, dan berilah aku petunjuk dan berilah kesehatan kepadaku dan berilah ampunan kepadaku.

bersambung…

Comments (1)

arti bacaan sholat (2)

September 13, 2008 at 3:03 am · Filed under attention plz!, sinau

AL FATIHAH

BISMILLAAH, ARRAHMAAN, ARRAHIIM
Dengan nama Allaah, Maha Pengasih, Maha Penyayang

ALHAMDULILLAAH, RABBIL ‘AALAMIIN. ARRAHMAAN, ARRAHIIM
Segala puji hanya milik Allaah, Rabb semesta ‘alam. Maha Pengasih, Maha Penyayang

MAALIKI YAUMIDDIIN
Penguasa, Hari Pembalasan/Hari Tempat Kembali

IYYAAKA NA’BUDU WA IYYAAKA NASTA’IIN
KepadaMulah, kami menyembah, dan kepadaMulah, kami mohon pertolongan

IHDINA, ASSHIRAATHAL, MUSTAQIIM
Tunjuki kami, jalan, golongan orang-orang yang lurus

SHIRAATHALLADZIINA AN’AM TA’ALAYHIM
Jalan, yang, telah Engkau beri ni’mat, kepada mereka

GHAYRIL MAGHDUUBI ‘ALAIHIM, WA LADDHAAAALLIIIN.
Bukan/Selain, (jalan) orang-orang yang telah Engkau murkai, dan bukan (jalan) orang-orang yang sesat.

bersambung…

Leave a Comment

arti bacaan sholat (1)

September 12, 2008 at 11:31 am · Filed under attention plz!, gado-gado, sinau

one of many ways to get our sholat preoccupied is tho understand the meaning of lafadz. here they are :

TAKBIR

ALLAAHU AKBAR
Allaah Maha Besar

ALLAHU AKBAR KABIIRA, WALHAMDULILLAAHI KATSIIRA, WA SUBHNALLAAHI BUKRATAW, WAASHIILA.
Allah Maha Besar, dan Segala Puji yang sangat banyak bagi Allah, dan Maha Suci Allah sepanjang pagi, dan petang.

INNII WAJJAHTU WAJHIYA, LILLAZII FATHARASSAMAAWAATI WALARDHA, HANIIFAM, MUSLIMAA, WAMAA ANA MINAL MUSRYKIIN.
Sungguh aku hadapkan wajahku kepada wajahMu, yang telah menciptakan langit dan bumi, dengan penuh kelurusan, dan penyerahan diri, dan aku tidak termasuk orang-orang yang mempersekutuan Engkau/Musryik.

INNASSHALAATII, WA NUSUKII, WA MAHYAAYA, WA MAMAATI, LILLAAHI RABBIL ‘AALAMIIN.
Sesungguhnya shalatku, dan ibadah qurbanku, dan hidupku, dan matiku, hanya untuk Allaah Rabb Semesta Alam.

LAA SYARIIKALAHU, WABIDZAALIKA UMIRTU, WA ANA MINAL MUSLIMIIN.
Tidak akan aku menduakan Engkau, dan memang aku diperintahkan seperti itu, dan aku termasuk golongan hamba yang berserah diri kepadaMu.

to be continued..

Leave a Comment

conditional in perl

September 9, 2008 at 10:30 am · Filed under iseng, sinau

there are two different conditional statements in perl for two different situations.
when comparing numbers/integers perl use == (double equals),
while comparing strings perl use eq (echo-quebec as in -eq shell).

example:
$a=”abcde”;
if ($a eq “abcde” ){
print “var a is not empty\n”;
} else {
print “var a is empty\n”;
}
if (length($a) == 5 ){
print “var a has 5 chars\n”;
} else {
print “var a dont have 5 chars\n”;
}

AFAIK you cant exchange those operator or else it’ll always return true and your conditioning is no use. CMIIW.

Leave a Comment

split partition @oracle

September 8, 2008 at 4:06 pm · Filed under sinau

lets say you have table purchase containing data of your products sales.
assuming you are using oracle and its support partitioning.
actually you’ve created daily partitions for each days transaction.
but somehow you missed a day and skip to the next day. e.g you’ve created partition sep_1_08 to sep_10_08, but you forgot to create the sep_7_08 partition.

normally if you have data that point to that missed partition it will return error :

ORA-14400: inserted partition key does not map to any partition

thats true. BUT ONLY if sep_7_08 is the last partition on table purchase.
BUT if THERE IS partition next to sep_7_08, oracle will automatically divert it to the nearest partition (mostly next partition available).
Yes, it will not return error and data transaction date 2008/09/07 will be inserted to partition sep_8_08 instead! aha!

now lets assume that you actually believe what i say. :P
the data is now mixed one with another. cant use partition name to determine dtm no longer..
so whats the solution?
relax.. hehehe, its ORACLE anyway… what thing oracle cant do huh? :P ~
try : alter table split partition.

heres the example for the case :
ALTER TABLE purchase
SPLIT PARTITION sep_8_08 AT (TO_DATE(‘ 2008-09-08 00:00:00′, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
INTO (
PARTITION sep_7_08 TABLESPACE tblspace_07 ,
PARTITION sep_8_08 TABLESPACE tblspace_08 )
PARALLEL ( DEGREE 9 );

some explanations :
ALTER TABLE purchase
i guess theres nothing to explain here, cristal clear right?

SPLIT PARTITION sep_8_08 AT (TO_DATE(‘ 2008-09-08 00:00:00′, ‘SYYYY-MM-DDHH24:MI:SS’,'NLS_CALENDAR=GREGORIAN’))
INTO (PARTITION sep_7_08 TABLESPACE tblspace_07 ,
PARTITION sep_8_08 TABLESPACE tblspace_08 )
note that you need to describe the date time format EXACTLY like the tables properties.
those lines mean every transaction in partition sep_8_08 which date is other than 2008-09-08 shall moved to partition sep_7_08. this means if you have several dates mixed (ow yeah thats trouble) you’ll need to do this step a couple of times, one by one, till partition sep_8_08 is cleared from “alien” data.

PARALLEL ( DEGREE 9 );
i dont really know what it is means.. sowi.. :D

feel confused? dont worry, so do i! heheheh
try google w/ keywords “alter table split partition oracle”.

Leave a Comment