terimakasih yach..
function nya bagus bgt. tinggal saya sesuain ma
kebutuhan saya..
salam hangat
-ashfi-
--- Indra Armansyah <[EMAIL PROTECTED]> wrote:
>
> 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]
>
>
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
