1. Using Graph Studio in Oracle Autonomous Database
  2. Work with Notebooks in Graph Studio
  3. Available Notebook Interpreters
  4. PGQL (RDBMS) Interpreter

PGQL (RDBMS) Interpreter

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 PGQL_icon 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.

Description of pgql-rdbms-create-pg.png follows
Description of the illustration pgql-rdbms-create-pg.png

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:

Description of pgql-rdbms-select-pg.png follows
Description of the illustration pgql-rdbms-select-pg.png

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