begin
begin
select max(col1) from table1 where col2='time' and col3='seconds';
exception
when no data found then
--how do I say here: if is for table1 do this
end;
begin
select count(col2) from table2 where colA = '0009393' and colB = 'cs23213'
exception
when no data found then
--..
--for table2 do this other
--..
end;
end;

create table green(
id number, 
intensity number);

insert into green values(1,100);
insert into green values(2,182);
insert into green values(3,140);
insert into green values(4,110);

create table blue(
freq number,
radix number);

insert into blue values(1, 900);
insert into blue values(2, 905);
insert into blue values(3, 950);
insert into blue values(4, 920);

declare
n number;
m number;
begin
select max(intensity) into n from green where id>5;
select count(radix) into m from blue where freq >5;
exception
when no_data_found then
dbms_output.put_line('Message NFD-: '||sqlerrm);
end;
/

SQL> set feedback 1
SQL> select max(sno) from test_tab where sno > 5;

  MAX(SNO)
----------


1 row selected.

SQL> select sno from test_tab where sno > 5;

no rows selected

SQL> select count(sno) from test_tab where sno > 5;

COUNT(SNO)
----------
         0

1 row selected.

SQL> ed
Wrote file afiedt.buf

  1  declare
  2  x number;
  3  begin
  4  select max(employee_id) into x
  5  from hr.employees
  6  where employee_id = 10;
  7  dbms_output.put_line('val: '||x);
  8* end;
SQL> /
val:

PL/SQL procedure successfully completed.

SQL> ed
Wrote file afiedt.buf

  1  declare
  2  x number;
  3  begin
  4  select count(employee_id) into x
  5  from hr.employees
  6  where employee_id = 10;
  7  dbms_output.put_line('val: '||x);
  8* end;
SQL> /
val: 0