Published January 22nd, 2010
in Uncategorized.
create or replace function inet_aton( p_str in varchar2 ) return
number
as
l_dot1 number := instr( p_str, ‘.’,1,1 );
l_dot2 number := instr( p_str, ‘.’,1,2 );
l_dot3 number := instr( p_str, ‘.’,1,3 );
begin
return
to_number(substr(p_str,1,l_dot1-1))*power(256,3)+
to_number(substr(p_str,l_dot1+1, l_dot2-l_dot1-1))*power(256,2)+
to_number(substr(p_str,l_dot2+1,l_dot3-l_dot2-1))*256+
to_number(substr(p_str,l_dot3+1));
end;
/
create or replace function inet_ntoa( ip_addr in integer ) return
string
as
begin
return
mod( trunc(ip_addr/256/256/256), 256 ) || ‘.’ ||
mod( trunc(ip_addr/256/256), 256 ) || ‘.’ ||
mod( trunc(ip_addr/256), 256 ) || ‘.’ ||
mod( ip_addr , 256 );
end;
/
select ip_addr, inet_aton( ip_addr ),inet_ntoa( inet_aton( ip_addr ))
from
(
select ‘209.207.224.90′ ip_addr from dual
)
/
original source: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2102503700346287503
Popularity: 7% [?]
Published December 7th, 2008
in Uncategorized.
26/12 lepas Nadiah genap tiga tahun. hari ini Danish pula genap satu tahun. Dari masa mak dia sarat dok mengandung kat dia, masa tu ulang alik pi UPSI, sampai ke la ni, aku punya kerja tak pernah habis, esok orang nak raya haji, aku dgn team sebok siapkan sistem yang akan UAT sealasa nanti. Dah seminggu aku langsung tak balik ke rumah, tidor kat hotel tempat kuarantin, dan minggu-minggu sebelum tu aku balik rumah pun sekadar cukup syarat. Dan tak lama lagi pulak, dia akan dapat adik. Kadang kala rasa kesian dekat si danish nih. aku mmg tak rapat dengan dia. Mungkin sebab aku tak rapat dengan dia tu yang dia jadi rapat sangat dengan mak dia, sampai kadang tak nampak mak dia sat pun menangis. Kadang sakit hati jugak bila aku pujuk dia tak mau, nak mak dia jugak tuh. Aku harap sindrom anak tengah tak terjadi dekat anak aku nih, dan aku sedar, aku dan kent kenalah memainkan peranan kami. Sebagai mak bapak kami hanya nak tengok hang berjaya suatu hari nanti, Selamat ulang tahun pertama Danish.
Pastinya, tahun-tahun yang mendatang Danish sendiri yang akan baca mesej ini, di waktu itu, kami harapkan hang telah menjadi seorang yang berjaya pada agama, bangsa dan negara. Amin.
Popularity: 36% [?]
Published November 26th, 2008
in Personal.
Selamat hari ulang tahun Nadiah 
Cepat sungguh masa berlalu. Jika 3 tahun lepas dia tahu menangis je, sekarang kadang-kadang tak larat nak layan dia bersembang. tot tet tot tett… Tak lama pasti dia dah nak masuk sekolah, alahai… Belajar baik-baik ye… jgn nakal-nakal ye… Sekarang Nadiah kalau bercakap, hujugnya mesti ada ye..
Popularity: 48% [?]
Published November 23rd, 2008
in Uncategorized.
Jumaat lepas adik aku konvo. Tahniah. Sekarang pastikan excel dalam degree pulak. Kesian kat adik aku nih, takde sapa teman. Kerja banyak punya pasal, aku terpaksa tak ambil cuti. Pagi-pagi buta pergi hantar drop dia aja sorang-sorang kat sana. Nasib baik bila keluar tengah hari ada yang menjemput. Ayah aku tak sihat lagi, masih ulang alik hospital. Tahniah la ye, jgn la sedih sampai keluar je dewan terus nak hantar jubah 
Popularity: 35% [?]
Published November 18th, 2008
in Work.
Kadang rasa kesian pulak kat anak aku yang nombor dua nih, kecik lagi nnt dah dapat adik. xde can dimanjakan langsung.
Popularity: 34% [?]
Published October 17th, 2008
in Uncategorized.
Jiwa aku kacau… arghhhh!!!!!
[Fri Oct 17 10:43:25 2008] [notice] child pid 911 exit signal Segmentation fault (11)
[Fri Oct 17 10:44:31 2008] [notice] child pid 1780 exit signal Segmentation fault (11)
[Fri Oct 17 10:44:59 2008] [notice] child pid 1781 exit signal Segmentation fault (11)
[Fri Oct 17 10:45:00 2008] [notice] child pid 1784 exit signal Segmentation fault (11)
[Fri Oct 17 10:45:03 2008] [notice] child pid 1785 exit signal Segmentation fault (11)
[Fri Oct 17 10:45:11 2008] [notice] child pid 1349 exit signal Segmentation fault (11)
[Fri Oct 17 10:45:12 2008] [notice] child pid 1776 exit signal Segmentation fault (11)
[Fri Oct 17 10:45:43 2008] [notice] child pid 2234 exit signal Segmentation fault (11)
[Fri Oct 17 10:47:08 2008] [notice] child pid 2236 exit signal Segmentation fault (11)
[Fri Oct 17 10:47:08 2008] [notice] child pid 2557 exit signal Segmentation fault (11)
[Fri Oct 17 10:56:46 2008] [notice] child pid 4918 exit signal Segmentation fault (11)
[Fri Oct 17 10:57:10 2008] [notice] child pid 4919 exit signal Segmentation fault (11)
[Fri Oct 17 10:57:45 2008] [notice] child pid 2608 exit signal Segmentation fault (11)
[Fri Oct 17 10:57:53 2008] [notice] child pid 2607 exit signal Segmentation fault (11)
[Fri Oct 17 10:59:45 2008] [notice] child pid 2703 exit signal Segmentation fault (11)
[Fri Oct 17 11:00:15 2008] [notice] child pid 2235 exit signal Segmentation fault (11)
[Fri Oct 17 11:07:33 2008] [notice] child pid 11400 exit signal Segmentation fault (11)
[Fri Oct 17 11:28:14 2008] [notice] child pid 11401 exit signal Segmentation fault (11)
Popularity: 37% [?]
Published October 15th, 2008
in Uncategorized.
harga minyak turun hari nih xdelah aku rajin pegi isi minyak malam tadi.
—
semalam, kira-kira jalam 8:10 malam, aku telepon mak nadiah, tapi dia yang angkat, katanya, “papa balik ye… papa balik ye papa ye” dengan nada sora nak nangis… alahai. Tahun ni mmg tahun yang jauh lebih sibuk berbanding tahun lepas. 2 hujung minggu lepas, aku sibuk di pejabat, urusan tender, hujung minggu yang lepas, aku sibuk di pejabat juga, urusan tender juga, hujung minggu ini pula, sibuk di pejabat lagi, urusan data migration, tak tahu la apa nak jadi dengan hujung minggu depan. lama dah tak bawa anak2 jalan…
p/s: vignette di atas original, sebab aku pakai uwa converter cap ayam hehe
Popularity: 36% [?]
Published September 13th, 2008
in Personal and Work.
Jam 9 exam, jam 6 pagi masih buat tender. Haizz.. dah tua-tua bangka pun exam lagi.
Popularity: 40% [?]
Published August 31st, 2008
in Personal and en.
Today is 31st August 2008, a Merdeka day. Inline with the buy local product spirit, we book a saga. Its for my wife. After this, she no longer needs to walk all the way to main road from our house with two kids, or find whatever we have in the freezer to cook, wait for cabs in the rain and then fetch our beloved kids from babysitter house whenever i’ve to stay back at the office or outstation. Its long due, but only recently my wife got her license, still L though.
Buying a car for my wife is no easy task dude. She put all kinds of terms and conditions to me, in fact she don’t even want it in the first place but i insist. The ultimate term is no monthly commitment, therefore have to pay in cash, huhuuu…
Felt like to book a nice no for the car, do you ever encounter such number like below. I found two so far, one on the PLUS highway and one parked at LHDN. Unique.
About a month ago, almost bought a car for Nadiah. Almost…
My wife saga should be ready for collection next Tuesday, god willing I’ll post about the car.
Popularity: 43% [?]
