Rest in peace DUAL ... no longer needed in 23c/23ai

preview_player
Показать описание
For 30 years we have been writing SELECT-FROM-DUAL to obtain the result of a single row expression. But now you will never have to type DUAL again!

Follow me!

The Podcast!

Subscribe for new tech videos every week

Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler

Note: Oracle Database 23c Free – Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify development of modern data-driven apps. The entire feature set of Oracle Database 23c is planned to be generally available within the next 12 months.

#sql #database #23c
Рекомендации по теме
Комментарии
Автор

wow oracle . after so many years they finally managed...

TheMrTalliban
Автор

Oh, I will miss all these stupid complains from developers, used to MySQL or PostgreSQL ... 🙂
Greetings from Germany!

QueryTuner
Автор

What is the advantage of not having dual in the select? Is it going to improve the performance in the database? or Is it only for reducing the coding or typing effort for Application Developers? I mean to ask as a DBA, do we get any benefit in the database side?

baskarbabu
Автор

When is general availability of production 23c? After the OCW?

thiruardura
Автор

Hello Connor, there is a typo mistake in the 1st statement you run on 23c, you wrote "FORM" Instead of "FROM" and the error was : from keyword not found.

sasa
Автор

I always get the c:\ sqlplus / as sysdba wrong. I always type sql pus 😂.

One less thing to worry about without from dual. Loving 23c!

AstorSkywalker