coba ini ya :
select length('INDONESIA')-length(Replace('INDONESIA', 'N', '')) from dual
Regards
Ferry S
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
> Behalf Of fata hudaya
> Sent: 11 August 2006 10:16
> To: [email protected]; [EMAIL PROTECTED]
> Subject: [indo-oracle] Menghitung jumlah karakter tertentu
>
>
> Dear,
>
> Saya mo tanya lagi nih,...
> Gimana ya Query untuk menghitung jumlah karakter tertentu dalam satu kata.
> c/o : INDONESIA
> Kalau kita akan menghitung berapa karakter 'N' maka hasil Query
> nya a/ 2 karakter.
>
> Thnx u/ solusinya...
> Best Regards,
>
> Fata Hudaya,
> +628567143271
> [EMAIL PROTECTED]
--
-----------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/
