Re: How do you search through multiple tables?

Something like this?

declare

        l_stmt varchar2(2000);
begin

        for X in (select table_name from user_tables where ...)
        loop
            l_stmt := 'select * from ' || x.table_name || ' where...';
            execute immediate l_stmt;
        end loop;