Re: Question Regarding Select Into
From: kumar <muthu.kumar_at_fmr.com>
Date: 28 Dec 2005 01:17:47 -0800
Message-ID: <1135761467.510505.58290_at_g47g2000cwa.googlegroups.com>
Date: 28 Dec 2005 01:17:47 -0800
Message-ID: <1135761467.510505.58290_at_g47g2000cwa.googlegroups.com>
[Quoted] Hi Mr. Frank
[Quoted] Thanks for correcting me. That number was just an example as
you rightly thought.
As mentioned in the earlier mail, i had tried this as well.
declare
2 a varchar2(30);
3 begin
4 select nvl(min(person_id),'asdf') into a from per_all_people_f
where person_id = 110;
5* end;
ERROR at line 1:
ORA-01722: invalid number
ORA-06512: at line 4
It gives an invalid number error. Should min function be passed a number field or it can have any other datatype field as its argument?. Received on Wed Dec 28 2005 - 10:17:47 CET