This repository contains projects developed during a university course on advanced and in-depth SQL, Oracle PL/SQL, and PostgreSQL PL/pgSQL. Each phase of the project builds upon the previous, ...

Example The client's browser will interpret the output of any PL/SQL code as plain text, and then format them according to the HTML code preceding the PL/SQL code segment.

Built an Oracle SQL and PL/SQL-based inventory system with normalized tables, constraints, and indexing. Developed procedures, functions, and triggers for real-time stock updates, reorder checks, and ...

When you use SELECT in a PL/SQL block, it’s important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.