Wednesday, April 26, 2023

Property Graphs in SQL Developer release 23.1

The Property Graph feature of Oracle Database offers powerful graph support to explore and discover complex relationships in data.

Oracle Database 23c Free - Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify the development of modern data-driven apps. The entire feature set of Oracle Database 23c is planned to be generally available within the next 12 months.

Oracle Database 23c Free – Developer Release includes support for using SQL to create and query property graphs, implementing the property graph specification in the SQL:2023 standard. You can now work with property graphs in SQL using any SQL worksheet in SQL Developer.

SQL Developer 23.1 includes the ability to list SQL property graphs in your database, just like you list tables and views:

Oracle Database, Oracle Database Career, Oracle Database Skills, Oracle Database Jobs, Oracle Database Tutorial and Materials, Oracle Database SQL, Oracle Database 23c
Listing SQL property graphs and creating a property graph using SQL

You can use the sample data and SQL on github to create a graph and run queries in SQL Developer when connected to Oracle Database 23c Free – Developer Release. Just load the data, run the sample CREATE PROPERTY GRAPH statement, and start running graph queries in SQL!

Using PGQL with Oracle SQL Developer


If you are a developer using the Property Graph Query Language (PGQL), SQL Developer 22.2 introduced a PGQL worksheet to run PGQL queries on Property Graph Views (PGQL property graphs). This worksheet been enhanced in SQL Developer 23.1. 

PGQL can be used to create and query graphs in Oracle Database 12.2 and later.

Oracle Database, Oracle Database Career, Oracle Database Skills, Oracle Database Jobs, Oracle Database Tutorial and Materials, Oracle Database SQL, Oracle Database 23c
Open a PGQL worksheet to run PGQL queries

Oracle Database, Oracle Database Career, Oracle Database Skills, Oracle Database Jobs, Oracle Database Tutorial and Materials, Oracle Database SQL, Oracle Database 23c
Listing PGQL property graphs

Source: oracle.com

Related Posts

0 comments:

Post a Comment