Hi Siva Sir, In this DDL vs DML. Is it right.? DML can be directly run in Blocks. Where DDL can't be directly run in Blocks ( need to use DynamicSQL for DDL's ). Please confirm. Thank you.!
hello, i have this question - if a table has 30 rows can 'A' be able to update 10 rows, 'B' be able update another 10 rows and 'C' be able to update the rest of the 10 rows at the same time
hi i have a doubt that in difference b/w Delete (DML) and Truncate video(DDL) u have mentioned that "no triggers gets invoked" in case of Truncate which is a DDL. But here in this u have mentioned as for DDL triggers ll get invoked. Please clarify. thanks in advance.
Hi I have small doubt regarding dml and ddl In the first video difference between delete and truncate you mentioned ddl trigger will not be invoked...but in the triggers you mentioned ddl trigger including truncate will be invoked...what's the difference can you explain.
@gopi, truncate won't trigger the ddl trigger, where as it trigger the ddl trigger if available, will explain in next video with an example, please stay tuned
Really great explained, thank you for the video. Well structered.
Welcome 💐🙏
You have done great job Sivaji.
Welcome bro
Thank you! What a great explanation 😊
Really informative
Thank you
Nice explanation
Thanks and welcome
hi Siva, can you post a video about oracle structure,what is schema,the relation user schema,database etc?
Hi Siva Sir,
In this DDL vs DML.
Is it right.?
DML can be directly run in Blocks. Where DDL can't be directly run in Blocks ( need to use DynamicSQL for DDL's ).
Please confirm. Thank you.!
Yes Arun, you are right 👍
One more, DDLs include reflecting the changes to Data dictionary views additionally
Thanks for adding
Sir if u don't mine..can i know the how to download Oracle database(sql.plsql) in laptop i3..64...
Alter table table_name enable row movement where table_name_attribute condition value; WHERE can be used in DDL statement also.
Dear sir,
Please make a lecturer on what is difference between left join and right join.
Sure bro, will add it soon, please stay tuned
hello, i have this question - if a table has 30 rows can 'A' be able to update 10 rows, 'B' be able update another 10 rows and 'C' be able to update the rest of the 10 rows at the same time
Yes
Is there any video on normalization? I had this question
Yes to post bro, please stay tuned
hi
i have a doubt that in difference b/w Delete (DML) and Truncate video(DDL) u have mentioned that "no triggers gets invoked" in case of Truncate which is a DDL. But here in this u have mentioned as for DDL triggers ll get invoked. Please clarify.
thanks in advance.
Please look into this video ruclips.net/video/THeY59Xw2RI/видео.html
Hi
I have small doubt regarding dml and ddl
In the first video difference between delete and truncate you mentioned ddl trigger will not be invoked...but in the triggers you mentioned ddl trigger including truncate will be invoked...what's the difference can you explain.
@gopi, truncate won't trigger the ddl trigger, where as it trigger the ddl trigger if available, will explain in next video with an example, please stay tuned
Hi Shiva,
Pls create video on Temp table.
Please look into this video
ruclips.net/video/-NLmzG2BZT8/видео.html
Hey Actually you leaved just one command in DCL and DML which is deny and select respectively
Sir, how to insert no of records from one table to another table .
insert into target table select * from source_table where
Can you answer this question please: DML vs DDL - what we need to be aware when mixed?
sure will post in next upcoming video, DDL is autocommit, so any DDL flowing DML will commit DML also
Ddl is autoslecet dml followes
SQL full course is available sir
Not yet bro
Dear sir, in ddL rename is missing.
Yes bro
Explain kriye