Oracle 23C New Features | SELECT Without FROM Clause

[@rahulmittal116]

I started watching your SQL videos in 2021 and till now I have switched 2 companies. You are just awesome Siva ! If one simply go through all your playlists, he/she will be expert in SQL. Once again thanks a lot from bottom of my heart. Be the same person as you are. Want to meet you in person in life once to thank u !!

[@SivaAcademy]

Its my pleasure to read your message, thank you so much, definitely we will meet, welcome again 💐🙏

[@jirehla-ab1671]

​@@SivaAcademydoes the 23c developer version have system resciurce limitation like a maximum of 12gb ram utilization, cause that's what I know abt the 23c free developer version

[@gnkgnk6296]

Very valuable Update in oracle 23c version thank you so much Siva garu from you

[@SivaAcademy]

My pleasure bro, thank you

[@sachingodbole6874]

It is very helpful in interview watching your updated knowledge on oracle new versions. Thanks for making upgraded version videos

[@SivaAcademy]

My pleasure, thank you

[@Yakshakaashi]

Thanks for the video. Please can you tell me all the features updates in 23c compared to older version like 12c of a Oracle. It helps.....

[@selvakumarkumar1543]

You always give great new things extraordinary. Pls upload more new features if it's there.

[@SivaAcademy]

Thank you, sure, please stay tuned for more video's

[@humayunhimu6045]

Interesting, it's like sql server

[@bijaychakravarty3505]

Awesome, In Google BigQuery we already have this Select without from, Now we will have it in Oracle as well

[@nareshtamiri2891]

Thank you so much for new update siva

[@SivaAcademy]

Welcome bro 💐

[@sunny7351]

Thank you. The same feature is already there in postgresql.

[@SivaAcademy]

Welcome, yes, this feature is in most other databases, from 23 only Oracle is supporting it

[@user-wl3le3ox7u]

can you please post videos related on join methods and access methods

[@SivaAcademy]

Sure, please stay tuned

[@md.selimhossain4181]

I think , In short the dual table is not mendatory in 23c. Thanks for update Siva.

[@SivaAcademy]

Yes, thank you

[@vamshisg]

First of all, Thanks for the video. It was a great learning for me. May I know what was the client tool being used here. The UI looks like Oracle SQL Developer, but it seems to be a different one. If it is different, was it a licensed software.?

[@SivaAcademy]

Thanks Vamshi, it was sql developer only, I just did made the editor window in float mode, that's why you saw slightly different

[@rahulmittal116]

Nice explanation sir

[@SivaAcademy]

Thank you

[@sravankumaryanamandra943]

boss is back 😄

[@SivaAcademy]

😃

[@godisthegreat6925]

Thank you very much sir

[@SivaAcademy]

Welcome bro

[@sagarjadhav299]

Good information sir

[@SivaAcademy]

Thank you bro

[@user-mb8vk1qz4e]

Great bro

[@SivaAcademy]

Thank you

[@vsr1727]

Thank you siva

[@SivaAcademy]

Welcome bro

[@nandu3349]

pls explain about ACID working in plsql

[@balramreddy1651]

in the vedio yu are using some highlihter software to highlight something can you tell me what software it is!

[@SivaAcademy]

ZoomIt - Sysinternals

[@balramreddy1651]

@@SivaAcademy Thank you Sir

[@himanish2006]

Good 🥳

[@SivaAcademy]

Thank you

[@iampratik90]

Is it for only expressions ?

[@SivaAcademy]

As for as no need to fetch from any table, for expression, functions, hard coded values, string literals etc..

[@sachingodbole6874]

Can we execute this queries in oracle live sql

[@SivaAcademy]

I haven't checked the current version of live sql, if its 23, then you can execute

[@user-ct2zt6tw4t]

sir i have installed 23 version sql developer but without from i cant able to execute

[@SivaAcademy]

Hi, you need the Oracle database version to be 23

[@user-ct2zt6tw4t]

thank you very much sir@@SivaAcademy