Categoria: SQL
-
When the Schema Does Not Speak Business: Testing Oracle 26ai Annotations for NL2SQL
A practical from-the-field test showing how Oracle 26ai annotations can reduce NL2SQL ambiguity by giving the database the business context that object names alone never carried.
-
Assertions in Oracle: one of those features that immediately made me think about old scars
A practical, from-the-field look at Oracle Assertions, showing how they can push real business rules like mandatory customer contact data and required justification for price reductions back into the schema in a more declarative way.
-
Updating XML Stored as CLOB in Oracle Using XMLQuery
Using a simplified shopping cart XML example, the content shows how to safely modify an XML element while properly handling namespaces and following the required copy / modify / return pattern defined by the XQuery standard. The example intentionally reflects real-world constraints, where the XML is already stored as CLOB and changing the data model…