Replies to This Discussion

Permalink Reply by Frankie Alter on June 10, 2013 at 1:55pm

why not simply handle the exception ?

create procedure xxxx
...
begin
....
begin
select whatever into wherever ....
do_something();
exception
when no_data_found then do_something();
when others then raise;
end;
end xxxx;
/

Permalink Reply by Felix Moret on June 10, 2013 at 1:58pm

Thannks for the Suggestion...this will solve my problem

But i just want to know that...Isn't there is any other better way to do it.

Thanks

Permalink Reply by Leoma Cheesman on June 10, 2013 at 1:59pm

Try using decode.
tableName: test

select decode((select testId from test),null,1,2) from dual;

If the record set is NULL, you will get 1 as output.
Else you will get 2 as output.

for more info,
http://eoracle11g.blogspot.com/

Permalink Reply by Leoma Cheesman on June 10, 2013 at 2:00pm

When using decode, don't forget to add
where rownum<2

because if there are multiple records in result set, inner query will throw an error.