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