Some new PL/SQL features in Oracle Database 23c

• 
• 
• 
• 
• 
• 

PrevNext

PL/SQL stands for Procedural Language for SQL. PL/SQL is Oracle’s procedural extension for SQL and is is loosely based on Ada (a variant of Pascal developed for the US Deptartment of Defense).  PL/SQL has been available in Oracle Database since version 6 (first released in 1992) while stored...

Continue reading

JSON Schema in Oracle Database 23c

In Oracle database 23c a JSON Schema can validate the structure and contents of JSON documents in your database.What is a JSON Schema?JSON is extremely flexible, but sometimes we want to validate the structure and contents of our JSON. A JSON Schema is a declarative language that allows...

Continue reading

SQL Property Graphs and SQL/PGQ in Oracle Database 23c

• 
• 
• 
• 

PrevNext

Oracle have had a Graph Server and Client product for some time, but in Oracle database 23c some of the property graph functionality has been built directly into the database.This article focuses on new SQL property graph feature and ignores the previous Graph Server product and PGQL.SetupWe create...

Continue reading

Language bindings for Autonomous Database: An overview for Developers

• 
• 

PrevNext

As databases evolve to be more autonomous and cloud-friendly, developers need efficient and reliable methods to connect and interact with them. This post will provide an overview on how to connect and query Oracle's Autonomous Database (ADB) from some popular programming languages and some of the differences in...

Continue reading