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

Leave a Reply

Your email address will not be published. Required fields are marked *

50 − forty five =