1. Graph Developer's Guide for Property Graph
  2. Getting Started with Oracle Property Graphs
  3. Property Graph Query Language (PGQL)
  4. Creating Property Graph Views Using PGQL

6.2 Creating Property Graph Views Using PGQL

You can create property graphs views on relational database tables.

The CREATE PROPERTY GRAPH statement in PGQL is used to create the property graph views.

See Example 3-1 for an example of a CREATE PROPERTY GRAPH statement used to create a property graph view.

The Java API in oracle.pg.rdbms.pgql package provides support for executing PGQL queries with a few exceptions.

Creation and querying of property graph views is supported in SQLcl. You can also query property graph views using the graph visualization tool. Both creation and querying of property graph views are not supported when using the Python API.

Also, the following PGQL SELECT features are not supported:

  • Recursive queries
  • Subqueries
  • in_degree and out_degree functions
  • Bind variables

Parent topic: Property Graph Query Language (PGQL)