+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: General (https://www.learnqtp.com/forums/Forum-General)
+--- Forum: Posting Guidelines/Disclaimer (https://www.learnqtp.com/forums/Forum-Posting-Guidelines-Disclaimer)
+--- Thread: Executing a sql having Single quotes in it.... (/Thread-Executing-a-sql-having-Single-quotes-in-it)
Executing a sql having Single quotes in it.... - venkatesan - 08-07-2012
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
RE: Executing a sql having Single quotes in it.... - QTPScript - 08-30-2012
Yes..You can do it easily
ADD DOUBLE " " AND IN IT..YOU WILL HAVE SINGLE QUOTE..
EXAMPLE
"SELECT FIRSTNAME FROM LEARNQTP WHERE NAME = 'QTPScript'"