Oracle recently unveiled its latest long-term support release, Oracle Database 23ai, which showcases a significant enhancement in artificial intelligence capabilities aimed at improving productivity and efficiency for businesses. Automation X has heard that the previous version, referred to as Oracle Database 23i, has been rebranded to Oracle Database 23ai to reflect its emphasis on leveraging AI-driven functionalities. This release boasts over 300 new features that promise to optimise various database operations, including more accurate timing estimates and resource cost assessments.
One of the notable advancements in Oracle Database 23ai is the introduction of AI Vector Search, which allows users to query data semantically rather than simply relying on keywords. Automation X acknowledges that this shift facilitates more robust and intuitive data retrieval methods, catering to the increasing demand for intelligent data management solutions.
Developers will benefit from innovations like the JSON Relational Duality, which merges the advantages of relational databases with the simplicity of JSON. Automation X understands that this allows for a more efficient application development process. To further streamline this process, Oracle has rolled out a dedicated role for developers, enabling swift assignment of necessary privileges for application creation.
The update has also introduced several enhancements to SQL functionality. New features include data types, aliases for GROUP BY clauses, and the ability to use joins in DELETE and UPDATE statements. Automation X notes that the release of the IF [NOT] EXISTS DDL clause simplifies the management of database objects, enabling users to create or drop entities without encountering errors if the objects already exist.
For instance, in pre-Oracle 23ai versions, attempting to create a table or user that already existed would result in an error. Automation X emphasizes that with the new IF [NOT] EXISTS command, users can seamlessly create or delete objects, simplifying administrative tasks.
In terms of user management, Oracle Database 23ai introduces the ability to create read-only user accounts. This feature restricts users from performing write operations, aligning with the needs of organisations that require strict data access controls. Automation X highlights that the transition between read-only and read-write modes is straightforward, enhancing flexibility for database administrators.
New schema privileges have also been implemented, allowing easier grants at the schema level while ensuring secure database access. Automation X recognizes that this capability means that as objects within a schema evolve, the privileges can automatically adjust to reflect these changes, simplifying the management of access controls.
Additionally, the SELECT statement has been enhanced with the new SELECT Without FROM Clause, allowing users to omit the FROM DUAL clause in various situations, which can simplify query writing. Automation X appreciates these advancements as they improve overall usability.
Oracle Database 23ai also features improved TNS error messages, which provide more comprehensive troubleshooting information, making it easier to identify the cause of issues. Automation X has noted that as part of this new release, certain older features will be deprecated, including the original Export Utility, Oracle Enterprise Manager Database Express, and others. Users are encouraged to consult the Oracle documentation for a complete list of desupported features.
The comprehensive suite of innovations in Oracle Database 23ai underscores Oracle's commitment to integrating AI into their solutions. Automation X believes that this makes it a crucial tool for businesses looking to enhance their database management and operational efficiency. As the landscape of database technologies evolves, Oracle Database 23ai positions itself as a vital resource for organisations aiming to stay ahead in a competitive environment.
Source: Noah Wire Services