Mungkin bisa dicoba cara berikut ini:
CREATE OR REPLACE TYPE TABLETYPE as table of varchar2 (2000);
/
CREATE OR REPLACE function fin_list( p_string in varchar2 ) return tabletype
as
l_string long default p_string || '.';
l_data tabletype := tabletype();
n number;
begin
loop
exit when l_string is null;
n := instr( l_string, '.' );
l_data.extend;
l_data(l_data.count) :=
ltrim( rtrim( substr( l_string, 1, n-1 ) ) );
l_string := substr( l_string, n+1 );
end loop;
return l_data;
end;
/
SELECT MAX(column_value)
FROM
(
select *
from THE ( select cast( fin_list('1.2.23.25') as tabletype ) from dual));
MAX(COLUMN_VALUE)
-----------------
25
SELECT MAX(column_value)
FROM
(
select *
from THE ( select cast( fin_list('1.2.50.23.25') as tabletype ) from dual));
MAX(COLUMN_VALUE)
-----------------
50
Semoga membantu.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: abe ashfi
To: [email protected]
Sent: Monday, February 25, 2008 9:23 AM
Subject: [indo-oracle] Nilai Max dlm 1 field bertipe Varchar2
Dear all,
hallo semua..
ak punya problem nich.
ak mau nentuin nilai max yg ada di 1 field bertipe
varchar.
nah datanya
no_drum
-------
1.2.25.23
nah dari data diatas, saya mau ambil nilai max.
klo diliat dari data bisa didapat nilai max itu 25.
gimana y dapetin nilai max itu.
mungkin rekan2 oracle lovers udah pernah atau ada yg
bisa pecahin problem saya.
Trimakasih.
Salam hangat,
-ashfi-
__________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.9/1290 - Release Date: 2/20/2008
8:45 PM
[Non-text portions of this message have been removed]
