Re: 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';
>
Enclose the quoted portion in 2 single quotes...

select 'select * from '||table_name|| ' where sample_column = ''foo'' from user_tables where table_name like ''%BLAH'';

• Note these are NOT " (quotes) but 2 of these ' (apostropheses)

Dan Hekimian-Williams Received on Thu Feb 10 2000 - 03:42:23 CET