1. Graph Developer's Guide for Property Graph
  2. Getting Started with Oracle Property Graphs
  3. Property Graph Query Language (PGQL)
  4. Executing PGQL Queries Directly Against Oracle Database
  5. Executing PGQL Queries Against Property Graph Schema Tables
  6. Using the oracle.pg.rdbms.pgql Java Package to Execute PGQL Queries
  7. Modifying Property Graphs through INSERT, UPDATE, and DELETE Statements
  8. Additional Options for PGQL Statement Execution

6.9.1.4.9.1 Additional Options for PGQL Statement Execution

Several options are available to influence PGQL statement execution. The following are the main ways to set query options:

  • Through flags in the modify options string argument of execute
  • Through Java JVM arguments.

The following table summarizes the main options for modifying PGQL statement execution.

Table 6-5 PGQL Statement Modification Options

Option Default Options Flag JVM Argument
Auto commit true if JDBC auto commit is off, false if JDBC auto commit is on AUTO_COMMIT=F -Doracle.pg.rdbms.pgql.autoCommit=false
Delete cascade true DELETE_CASCADE=F -Doracle.pg.rdbms.pgql.deleteCascade=false

Parent topic: Modifying Property Graphs through INSERT, UPDATE, and DELETE Statements