Part II SQL Property Graphs

Learn and work with SQL property graphs.

Effective with Oracle Database Release 23c, you can create and query SQL property graphs.

The following chapters provide in-depth information on SQL property graphs:

• Introduction to SQL Property Graphs
  You can work with SQL property graphs in any SQL based interface (such as SQL Developer, SQLPLUS, or SQLcl) or from a Java program using JDBC.
• SQL DDL Statements for Property Graphs
  You can create, revalidate, and drop SQL property graphs using SQL data definition language (DDL) statements.
• SQL GRAPH_TABLE Queries
  You can query a SQL property graph using the GRAPH_TABLE operator to express graph pattern matching queries.
• Loading a SQL Property Graph into the Graph Server (PGX)
  You can load a full SQL property graph or a subgraph into memory in the graph server (PGX).
• Executing PGQL Queries Against SQL Property Graphs
  You can directly run PGQL queries against a SQL property graph in the database.