Category: Development

Simplifying SQL: Oracle 23ai Unveils the Boolean Data Type

With each release, Oracle continues spearheading database innovation and enhancing data management technologies. The introduction of the SQL Boolean and Vector data type in Oracle Database 23ai is a testament to this, offering significant enhancements designed to streamline database operations and sync seamlessly with application development. It provides the foundation

Read More »

Oracle Database Editions – Feature Availability by Edition

eSolution a Canadian based Oracle Professional Services company can help you choose the right version of Oracle Database and other products by assessing your needs diligently. Do you really need to get the Enterprise Edition license of Oracle Database or could you stay with the Standard Edition and save a

Read More »

Oracle Database XE 18c – System Requirements

System Requirements for Oracle Database Express Edition (XE) 18c. For Linux x86-64 Operating System Linux x86-64 operating system requirements The following Linux x86-64 kernels are supported: Oracle Linux 7 with the Unbreakable Enterprise Kernel 3: 3.8.13-35.3.1.el7uek.x86_64 or later Oracle Linux 7.2 with the Unbreakable Enterprise Kernel 4: 4.1.12-32.2.3.el7uek.x86_64 or later

Read More »

Oracle Database – Sequence Enhancement in PL/SQL

Oracle Database 11g – Sequence use in PL/SQL – One of the language enhancements that was introduced in 11g is the use of sequence pseudocolumns, NEXTVAL and CURRVAL, in any PL/SQL context when an expression of NUMBER datatype may appear. This is now the preferred method of calling sequences in

Read More »

Oracle Application Express – APEX

Oracle Application Express (APEX) Oracle Application Express is the hidden gem in your Oracle database which allows for full application development right from within your Oracle database. eSolution provides expert consulting services on this simple and yet comprehensive platform from Oracle.  Oracle Application Express or APEX has not made a very big

Read More »