Sori ralat lagi (salah copy pasteJ) : Untuk menghitung jumlah karakter X dari satu baris data terdiri dari beberapa kolom : select (length(Sen||Sel||Rab||Kam||Jum||Sab||Mgg) - length(replace(Sen||Sel||Rab||Kam||Jum||Sab||Mgg,'X',''))) as Number_of_X_in_a_Line from Table_Name where Condition BTW, sekalian mo test, apa e-mail saya bisa diterima direkan-rekan di milist ? apakah dobel-2 diterimanya ? dsb. Soalnya saya baru beberapa hari yang lalu bergabung. Please kindly kasih tau ya... Chul Solichul HADI <[EMAIL PROTECTED]> wrote: Untuk menghitung jumlah karakter X dari satu baris data terdiri dari beberapa kolom :
select (length(Sen||Sel|Rab|Kam||Jum||Sab||Mgg) - length(replace(length(Sen||Sel|Rab|Kam||Jum||Sab||Mgg,'X',''))) as Number_of_X_in_a_line from Table_Name where Condition ----- Original Message ----- From: Asep Inbisco IT To: [email protected] Sent: 18 September 2006 9:29 Subject: [indo-oracle] BAGAIMANA CARA BACA JUMLAH CHARACTER? Dear teman-teman, saya punya satu baris record yg kira2 bentuknya spt ini : Sen Sel Rab Kam Jum Sab Mgg O X O O X X O Bagaimana cara mengetahui berapa jumlah character 'X' yang ada pada 7 kolom tersebut dan menuliskannya pada query? Please teman2 ...sudah butek nih tolong pencerahan dari teman2 semua. terimakasih [Non-text portions of this message have been removed] =================================================== This Mail Scanned By Messaging Security Suite ================= Provided by IT Hardware ================= [Non-text portions of this message have been removed] -- -----------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 --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. [Non-text portions of this message have been removed] -- -----------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 --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1ยข/min. [Non-text portions of this message have been removed] -- -----------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/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
