select LENGTH(TRIM(TRANSLATE('12345', ' +-.0123456789',' '))) from dual--return NULL
select LENGTH(TRIM(TRANSLATE('12345a', ' +-.0123456789',' ')))from dual--return 1 kalau
select LENGTH(TRIM(TRANSLATE('abc12345a', ' +-.0123456789',' '))) from dual --return 4
so kalau dia NULL dia akan numeric..IS NOT NULL bukan numeric
p/s : diletakkan dalam blog ini supaya aku senang carik..abaikan kalau x paham.. :))
Thursday, August 2, 2012
Subscribe to:
Post Comments (Atom)
2 comments:
terima kasih cikgu
muahahaha..cikgu yerrr..sama2 aizumi
Post a Comment