create table anggota(id number(2), nama varchar2(25), umur number(2)); insert into anggota values(1,'Rudi Wirmansyah',27); insert into anggota values(2,'Sulastri',20); insert into anggota values(3,'Julian Thamrin',23); insert into anggota values(4,'Agus Setiawan',36); insert into anggota values(5,'Kunia Rini Sulistyowati',27); insert into anggota values(6,'Amir Alam',23); commit;
select nama from anggota where length(nama)=(select max(length(nama)) from anggota); NAMA ------------------------- Kunia Rini Sulistyowati Salam, Indra Armansyah [EMAIL PROTECTED] ----- Original Message ----- From: eko setiaji To: [email protected] Sent: Tuesday, November 28, 2006 4:16 PM Subject: FW: [indo-oracle] Gimana sich cara mencari string terpanjang v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}..shape {behavior:url(#default#VML);} Mas indra…thx sebelumnya…. Tapi koq…hasil yang ditampilkan… Nama 20 20 20 20 …dst Klo 20 itu lebar field utk nama…, Mslhny perintah : max(length(nama))di oracle itu menampilkan lebar field, bukan utk mencari menghitung jumlahkarakter….. jadi gimana donk mas? Makasih --------------------------------- From: [EMAIL PROTECTED]:[EMAIL PROTECTED] OnBehalf Of Indra Armansyah Sent: 25 Nopember 2006 8:24 To: [email protected] Subject: Re: [indo-oracle] Gimanasich cara mencari string terpanjang Bisa dicoba query berikut ini: select nama from anggota where length(nama)=(select max(length(nama)) from anggota); Salam, Indra Armansyah [EMAIL PROTECTED] ----- Original Message ----- From: eko setiaji To: [email protected] Sent: Thursday, November 23, 2006 1:33 AM Subject: [indo-oracle] Gimana sich cara mencari string terpanjang Haloo semua,..... mo minta tolong nich... gimana ya caranya mencari string terpanjang dari sebuah kolom tabel Contoh dr tabel anggota: ID Nama Umur 1 Rudi Wirmansyah 27 2 Sulastri 20 3 Julian Thamrin 23 4 Agus Setiawan 36 5 Kunia Rini Sulistyowati 27 6 Amir Alam 23 dst nha yg diminta jwbny : Kurnia Rini Sulistyowati koq ga bisa ya pake : select nama from anggota where length(nama)=max(length(nama)); toloooong donk... makasih ya sebelumnya.... Send instant messages to your online friends http://uk.messenger.yahoo.com ---------------------------------------------------------- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.0.409 / Virus Database: 268.14.14/548 - Release Date: 11/23/2006 [Non-text portions of this message have been removed] Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.0.409 / Virus Database: 268.14.19/555 - Release Date: 11/27/2006 [Non-text portions of this message have been removed]
