like keyword (full table scan)?
From: tone <dmclaude_at_yahoo.com>
Date: 13 Aug 2002 11:59:15 -0700
Message-ID: <5fff533a.0208131059.11c11754_at_posting.google.com>
Date: 13 Aug 2002 11:59:15 -0700
Message-ID: <5fff533a.0208131059.11c11754_at_posting.google.com>
return;
end user_search;
=====my way============================>
procedure Search (userin IN INTEGER, custin IN INTEGER, errorcode OUT
INTEGER) as
v_user_id VARCHAR2(13);
v_cust_id VARCHAR2(13);
cursor CUR is
SELECT * FROM ippprg.pni WHERE acno LIKE v_acno AND chkno LIKE v_chkno ;
begin
IF userin is NULL THEN
v_user_id := '%';
ELSE
v_user_id := userin;
END IF;
IF custin is NULL THEN
v_cust_id := '%';
ELSE
v_cust_id := custin;
END IF;
errorcode := 0;
for each_row in CUR loop
dbms_output.put_line(each_row.user_id);
end loop;
end Search;
---------------end sample code -------------> Received on Tue Aug 13 2002 - 20:59:15 CEST