You can run PGQL queries directly against your property graph data in Oracle Database using the PGQL-RDBMS interpreter in Graph Studio.

In addition to creating the property graphs from the Graphs page, you can now create these graphs directly in the database using the PGQL-RDBMS interpreter.

Tip:

You can hover over the bottom part of a notebook paragraph and click the Add PGQL-RDBMS Paragraph icon to open a PGQL (RDBMS) paragraph instantly in the notebook.

The following example shows the creation of a PGQL Property Graph using the CREATE PROPERTY GRAPH statement in a PGQL (RDBMS) paragraph.

PGQL (RDBMS) paragraphs begin with %pgql-rdbms.

You can then run PGQL INSERT, SELECT, UPDATE or DELETE queries directly on the graph without having to load the graph into memory. See Executing PGQL Queries Against PGQL Property Graphs in Oracle Database Graph Developer's Guide for Property Graph for more information.

For example, the following figure shows the graph visualization output using a PGQL SELECT query on the PGQL Property Graph created in the earlier example:

Also, see the table in Supported PGQL Features and Limitations for more information on the supported PGQL functionalities for the graphs in the database.