Oracle Database 23ai is the next long-term support release and offers over 300 new features. Originally named Oracle Database 23i, it was rebranded to Oracle Database 23ai with a heavy focus on ...

In the realm of database management, Oracle PL/SQL stands out as a powerful and versatile language for developing robust applications. As a seasoned PL/SQL developer, you understand the importance of ...

QR Codes Generator package provides functionality to quickly and efficiently generate QR Codes (module 2) directly from Oracle database. It requires no additional ...

PL/SQL Unwrapper for SQL Developer is a free extension to unwrap PL/SQL code wrapped with the wrap utility of the Oracle Database Server version 10g, 11g, 12c, 18c or 19c. Open a wrapped PL/SQL unit ...

Major upgrade to the ever-evolving Oracle Database brings JavaScript support, graph optimizations, in-memory enhancements, and dramatic improvements to JSON operations and in-database machine learning ...

I will show how to pivot tables using the PIVOT clause. How to add a summary column and the summary row to the result: We need to have data to analyse. All examples in this post are based on the ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...