Oracle AI Database 26ai(26.23.4) introduces a useful SQL enhancement that allows the * wildcard to be combined with explicit column names, constants, and SQL expressions in the same SELECT list.

Before the 23.26.4 release, Oracle did not allow * to be used alongside other select-list items in this way:

Oracle AI Database 26 ai Free Release 23 . 26 . 3 . 0 . 0 - Develop , Learn , and Run for Free Version 23 . 26 . 3 . 0 . 0

SQL > select id , * , fname from person ; select id , * , fname from person * ERROR at line 1 : ORA - 00936 : missing expression Help : https : // docs . oracle . com / error - help / db / ora - 00936 / The asterisk cannot be combined with explicit column names in this statement , so the query fails with ORA - 00936 .

Enter fullscreen mode

Exit fullscreen mode

Now, the same query executes successfully on Oracle AI Database 23.26.4 :

Oracle AI Database 26 ai Enterprise Edition Release 23 . 26 . 4 . 0 . 0 - Production Version 23 . 26 . 4 . 0 .…