In Oracle 23ai you can now update one table using values from another and limit the rows changed in DELETE and UPDATE This makes the database more developer friendly and increases SQL standard support and provides parity with other non-Oracle
GROUP BY Column Alias or Position in Oracle 23ai
In Oracle 23ai database you can now GROUP BY using an alias or column position. This means you no longer have to write aggregation groups containing certain expressions several times and it will just simplify your SQL query writing. GROUP
SELECT without FROM DUAL in Oracle 23ai Database
Oracle 23ai database gets rid of FROM DUAL in SELECTs. Now you can remove the FROM when performing simple calculations or getting SYSDATE etc. OLD – select sysdate from dual; 23ai – select sysdate; OLD – select 23+6 from dual;
IF EXISTS and IF NOT EXISTS in SQL in Oracle 23ai Database
Oracle 23ai database now allows you to use IF EXISTS and IF NOT EXISTS. e.g. CREATE TABLE IF NOT EXISTS demo (d_id number, d_name VARCHAR2(10)); DROP TABLE IF EXISTS demo; This helps with portability of code across vendors and also