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.
• Getting Started with the Graph Visualization Extension for VS Code
  Oracle SQL Developer Graph Visualization for VSCode enables you to visualize the results of SQL graph queries when using Oracle SQL Developer for Visual Studio Code (VS Code).