SQL & PL/SQL

Hi
IN _10gR2_
I would like to know if there is a way to change the tablename at runtime - other than using dynamic sql.

These table have similar structure except the tablename iteself.

For ex. depending on where we get a request we want to look/update different table:

if request_from x then
select * from table where ....
or it could be update or insert statement here
end if;

if request from y then
select * from table_y where ....
or it could be update or insert statement here
end if;

Thanks