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 ) || ‘.’ [...]
Archive for the 'Uncategorized' Category
MYSQL Equivalent INET_NTOA and INET_ATON for Oracle
Published January 22nd, 2010 in Uncategorized. 0 Comments26/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 [...]
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 [...]
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 [...]
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, [...]
Too many tweet. Tweeter down yet again, for a short while though. And the error picture is sweet too.
In most cases, it is not. But as long as people love and can’t live without it, it is OK. Take a look at Twitter. I’ve been active using twitter (http://twitter.com/shutterspeaks) lately, and I can’t count the error message they are fixing, almost everyday there is a problem, and it’s not the same.
All I’m saying, [...]
Kata Dr Sheikh Muszaphar Shukor Sheikh Mustapha:
“Saya harap kementerian akan lebih giat lagi dalam mempromosikan program penerokaan angkasa lepas kepada pelajar kerana saya lihat kita seperti tiada tujuan.
“Tidak tahu ke mana arah program angkasawan ini,” katanya
Actually this is a keychain. A door gift from my friend, ijat on his wedding day 25th/12/2007.
Taken just now, no heavy PP except cropping and a bit exposure adjusting to get the white bg on the bg itself. Da boring ngadap proposal THIS, ngadap jap mende ni hehe.
