Re: is there a simpler way to do this?
From: Jeff Piatt <member25196_at_dbforums.com>
Date: Sat, 22 Feb 2003 03:15:24 +0000
Message-ID: <2560987.1045883724_at_dbforums.com>
Date: Sat, 22 Feb 2003 03:15:24 +0000
Message-ID: <2560987.1045883724_at_dbforums.com>
Yes, use a singleton select (select... into...) along these lines:
declare
n_ID daily_changes.change_ID%TYPE;
begin
select max(change_ID)
into n_ID
from daily_changes
where daily_id = 1;
dbms_output.put_line(n_ID);
end;
-- Posted via http://dbforums.comReceived on Sat Feb 22 2003 - 04:15:24 CET