Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It’s not possible to gain the DDL lock to compile a package while it’s being executed, so how do you do so without downtime? In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy…

  Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It’s not possible to gain the DDL lock to compile a package while it’s being executed, so how do you do so without downtime? In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy…

  Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It’s not possible to gain the DDL lock to compile a package while it’s being executed, so how do you do so without downtime? In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy…

  Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It’s not possible to gain the DDL lock to compile a package while it’s being executed, so how do you do so without downtime? In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy…

  Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It’s not possible to gain the DDL lock to compile a package while it’s being executed, so how do you do so without downtime? In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy…

PL/SQL includes a versatile exception handling facility. Using it effectively can yield robust and efficient code. When mis-used, it can make troubleshooting harder or mask issues. This session will explore how to use PL/SQL Exceptions to your advantage and avoid common pitfalls. Whitepaper PowerPoint

Oracle Database 12c brings PL/SQL enhancements in these categories: transparent performance improvements; new PL/SQL language features for better performance, new functionality, and improved programming usability; and new supplied package APIs. This session explains improvements in PL/SQL-to-SQL interoperability, improvements in how PL/SQL subprograms can be invoked from outside of the database, new constructs to improve modularization,…

Oracle Database 12c brings PL/SQL enhancements in these categories: transparent performance improvements; new PL/SQL language features for better performance, new functionality, and improved programming usability; and new supplied package APIs. This session explains improvements in PL/SQL-to-SQL interoperability, improvements in how PL/SQL subprograms can be invoked from outside of the database, new constructs to improve modularization,…

Oracle Database 12c brings PL/SQL enhancements in these categories: transparent performance improvements; new PL/SQL language features for better performance, new functionality, and improved programming usability; and new supplied package APIs. This session explains improvements in PL/SQL-to-SQL interoperability, improvements in how PL/SQL subprograms can be invoked from outside of the database, new constructs to improve modularization,…

It is impossible to think of PL/SQL without also thinking about SQL operations because the main purpose of PL/SQL is to provide the fastest and most efficient way of extending the relational database environment into the realm of procedural logic. The most important thing to remember is that SQL and PL/SQL are completely separate languages,…