Executing a sql having Single quotes in it....

[venkatesan]

I want to execute a sql which is having single quotes in it....

sql = " select 'update '||column_name||' ' from all_tab_columns "

Since i have used the single quote inside the query, part of the query is commented due to singel quotes. Is anyway we can execute the query?

Please advice on this....


Thanks,
Venkatesh