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;
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;