Radu Pârvu

Notes on tech, tools, and thinking

    Welcome to Radu Parvu’s site on tech and news of the world!

    SQL Assertions in Oracle: From Theory to Practice with Oracle AI Database

    March 2026

    • SQL Assertions in Oracle: From Theory to Practice with Oracle AI Database

      SQL Assertions in Oracle: From Theory to Practice with Oracle AI Database

      SQL assertions are defined in the standard but are rarely implemented in real databases due to performance and complexity challenges. Vendors like Oracle opt for simpler constraints, such as triggers and stored procedures, to maintain global integrity rules. Consequently, this reflects a gap between theoretical relational models and practical implementations. The evolution shows a preference…

    • Oracle SQL: DELETE … RETURNING: Efficient Data Removal with Immediate Feedback

      Oracle SQL: DELETE … RETURNING: Efficient Data Removal with Immediate Feedback

      The article discusses the Oracle Database feature “DELETE … RETURNING,” which allows for the deletion of rows while simultaneously retrieving data from those rows. This simplifies operations, reduces network round-trips, and enhances performance. It highlights Oracle’s advanced capabilities, making it invaluable for efficient data manipulation and maintaining records in enterprise systems.

    • Creating a free Linux OS lab environment on Oracle’s OCI

      Creating a free Linux OS lab environment on Oracle’s OCI

      Introduction Creating a free Linux virtual machine on Oracle Cloud Infrastructure (OCI) is one of the best ways to experiment with cloud computing without spending [a lot of] money. Oracle offers an Always Free tier that includes ARM and AMD-based virtual machines, storage, and networking resources at no cost.This step-by-step guide walks you through the entire process. Why Use OCI…