The provided examples for the new GRAPH_TABLE Operator in 23c in the SQL Language Reference https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/graph_table-operator.html#GUID-CA6A600E-2087-46F8-A081-C6F3F01CF305__GUID-3D99E9E8-9FA0-4E3F-B03D-2192CFBC8349 are incomplete and wrong.
1. Table CREATE TABLE works_at is defined twice
2. Table message used in MyGraph is missing
3. As a result the property graph MyGraph cannot be created and the example query does not work. Furthermore, query contains smart quotes (’) instead of single quotes (').
I also checked the examples defined in https://docs.oracle.com/en/database/oracle/property-graph/23.1/spgdg/sql-graph_table-queries.html#GUID-E7D37405-D243-4B02-8108-E6EB7FC47DA3 . They use a different model with a very tiny data set.
It would be nice if this example in the SQL Language Reference manual could be extended with some data so that the query does not always return empty results. An additional schema as part of https://github.com/oracle-samples/db-sample-schemas would be great. Such a schema could be referenced in the SQL Language Reference manual.