sql - How to add where clause condition of type varchar in dbms_xmlgen.getxml? -


this query trying

select dbms_xmlgen.getxml('select * city city_name="rome"') xml dual 

but giving error.

image description here

when tried select dbms_xmlgen.getxml('select * city city_id=10446') xml dual worked fine.

please can 1 tell me how add condition varchar type?

try using pair of single quote eg:

 select dbms_xmlgen.getxml('select * city city_name=''rome''  ') xml dual 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -