SQL*Plus question

I've got a really simple requirement.
Basically all I want to do is:

select * from table1 where key=value;
if found
display it;
else
select * from table2 where key=value;
display it;
end if;

I want to do it in the simplest possible .sql script so I can just invoke it from SQL*Plus. Should be standing-on-your-head stuff but I'm struggling to get my head around the interaction between SQL*Plus, SQL and PL/SQL in this.
What should the script look like?

Many thanks

Andy Kent Received on Mon Jan 31 2005 - 09:44:13 CST