Oracle 23C New Feature | Direct Joins for UPDATE and DELETE Statements

Oracle 23C New Feature | Direct Joins for UPDATE and DELETE Statements

00:00 Introduction
00:43 SQL Server Example
06:16 Oracle 21C Example
08:46 Oracle 23C Example

--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

--------------------------------------------------------------

[KrishnaKumar-fckl]

Good information. I am expecting more information from you. Thank you.

[theboss]

Thank you bro... waiting for talend series

[bhaskarreddy]

Hello Siva Bro.. I have been watching your videos since last one month. It is giving more confident where i not used advanced concepts through your videos and meaning full explanation is giving me more learning.. I would so thank you if you teach and post videos about Performance tuning concepts like Hints, SQL Tuning, explain plan like other videos related Performance tuning as need to know as my experience .. Keep waiting for your Videos ..Once again thank you for posting kind of explanation videos....

[thamaraiselvanboopathi]

Hi Siva ... First of all thanks for your valuable videos... Much appreciation... Can u please explain about Oracle optimizer joins, cost calculation, query optimization...Please make it

[DeepaGadankush-lbcm]

Hi Sir, I have one query regarding db link, e.g. I have created db link on consider abc table from db 1 and I want to update to that table from another database is it possible, which grants are required ?

[hanumanthreddy]

I am trying to contact via email but I didn't find
My question is I have table emp have 3m records in sit1 want load same data in uat .
How we can do

[India_]

Thanks for this update, Oracle code wont look the same from this version

[sandeepchettupally]

Hi Bro can you please make video on queue in oracle and their real time use.

[ravipatisrikanth]

Hi sir I mailed you one question can you please provide the solution for this question

[manjutharak]

Hi bro do video on snowflake and snowflake job in future