- Success Stories
Success Stories
McMaster University: Exadata Cloud@Customer Case Study
Eclipsys has helped McMaster University maximize its investment in the Oracle Exadata Cloud@Customer solution. Read the story here
- Careers
Life at DSP-Eclipsys
- About
Getting to know us
- Contact Us
Blog: Oracle 23ai (2)
-->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..
Oracle 23ai: Read-Only Users and Sessions
Overview: Oracle 23ai Database introduces a new feature to control whether a user or session is enabled for read-write operations, irrespective of the privileges of the user that..
Oracle 23ai: Hybrid Read-Only Mode for Pluggable Databases
Overview: Oracle 23ai database introduces a new feature to open Pluggable database in a new mode called hybrid read-only Hybrid read-only mode enables a PDB to operate as either..
Oracle 23ai: INTERVAL Data Type Aggregations
Overview: Oracle 23ai introduces the use of SUM and AVG functions with INTERVAL datatype This enhancement makes it easier to calculate totals and averages over INTERVAL values In..
Popular Post
