- Careers
Life at DSP-Eclipsys
- About
Getting to know us
- Contact Us
Anas Darkal
-->Latest Posts
Oracle 23ai: Lock Free Reservations Capability
Overview: In previous database releases when a column value of a row is updated by adding or subtracting from it, all other updates to that row are blocked until the transaction..
Oracle 23ai: Unrestricted Parallel DMLs
Overview: Oracle database allows DML statements to be executed in parallel mode by breaking the DML statements into exclusive smaller tasks. However, in releases prior to Oracle..
Oracle Database 23ai: Fetch Top-N Rows Per Group Queries
Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..
Oracle 23ai: Enumeration Domains – List of Values in the Database
Overview: Oracle Database 23ai introduces a new way to create lists of values: enumeration (enum) domains Benefits: Create lists of name-value pairs in the database Query the enum..
Oracle 23ai: Quick Overview
Oracle Database 23ai Oracle Database 23ai is the next long-term support release of Oracle Database It brings AI to your data with the addition of AI Vector search to Oracle’s..
Oracle 23ai: Bigfile Tablespace Shrink
Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond requested RESIZE value” because there are..
Oracle 23ai: Managing Flashback Database Logs Outside the Fast Recovery Area
Overview: In previous Database releases, you could store flashback database logs only in the fast recovery area Oracle 23ai Database introduces the option to store flashback..
