Dynamic SQL

Hello all:
I am having problem with this dynamic sql because of the single quote around foo. Is there a way around it?

select 'select * from '||table_name|| ' where sample_column = 'foo'' from user_tables where table_name like '%BLAH'; Received on Wed Feb 09 2000 - 19:59:25 CST