0

i have an XML file of queries that look like this:

<queries>
    <query queryType="statement" query="alter session set "_ORACLE_SCRIPT"=true" ignore="false">
        <auditEventVerifications normalizedQuery="alter session set "_oracle_script"=true">
        </auditEventVerifications>
    </query>
.
.
.

i want my query to be: alter session set "_ORACLE_SCRIPT"=true

but the inner quotation marks make the file compiles with errors. how can I mark the inner quotation?

doing this: \ "_ORACLE_SCRIPT\ " didn't work.

Orly Orly
  • 367
  • 5
  • 16

1 Answers1

0

change the query to query='alter session set "_ORACLE_SCRIPT"=true' did the work!

Orly Orly
  • 367
  • 5
  • 16
  • 1
    Isn't that exactly what you posted originally? – kjhughes Jan 17 '22 at 14:57
  • 1
    I see that you've now edited the `query` attribute to `query="alter session set "_ORACLE_SCRIPT"=true"`. Right, that wouldn't have worked as it wouldn't have been well-formed XML. – kjhughes Jan 18 '22 at 14:02