Dynamic SQL

From: My Name <gxck_at_mindspring.com>
Date: Wed, 09 Feb 2000 20:59:25 -0500
Message-ID: <38A21B7D.C4C673E6_at_mindspring.com>

Hello all:
[Quoted] [Quoted] I am having problem with this dynamic sql because of the single quote [Quoted] 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 Thu Feb 10 2000 - 02:59:25 CET