Part II SQL Property Graphs

Learn and work with SQL property graphs.

Effective with Oracle Database 23ai, 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, rename, and drop SQL property graphs using SQL data definition language (DDL) statements.
• SQL Graph 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.
• Visualizing SQL Graph Queries Using the APEX Graph Visualization Plug-in
  You can use the Oracle Application Express (APEX) Graph Visualization plug-in to visualize and interact with SQL property graphs in an APEX application.