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.

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