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;
23ai – select 23+6;
This brings it into line with other databases and will make coding simpler.
SELECT without FROM DUAL in Oracle 23ai Database