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

[QTPScript]

Yes..You can do it easily

ADD DOUBLE " " AND IN IT..YOU WILL HAVE SINGLE QUOTE..

EXAMPLE

"SELECT FIRSTNAME FROM LEARNQTP WHERE NAME = 'QTPScript'"