Oracle Difference between Delete and Truncate | Oracle Delete vs Truncate

  Рет қаралды 269,882

Siva Academy

Siva Academy

Күн бұрын

Пікірлер: 241
@raju26067
@raju26067 6 жыл бұрын
One of the best lectures that i have seen in youtube for Database developers.... Thank you very much.....
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Thanks for your comments Raju :-)
@naimuddinsiddiqui9249
@naimuddinsiddiqui9249 Жыл бұрын
Hi developers, I am preparing for SQL Interviews Is it worthy to follow this playlist I am bit confuse because there is many Oracles playlist in this channel like 12C, 18C I am a nob person in this SQL or Oracle. Any guidance or suggestion would be Highly appreciable Thanks !
@amanpandey4907
@amanpandey4907 3 жыл бұрын
Sir, you should write a book, really helps to get all this on book, if there is any pdf available pls suggest ways to get it.
@C.K.Arun.
@C.K.Arun. Жыл бұрын
Hello Friends and Siva Sir, i am Preparing for Oracle Certification. For the past weeks I watched your video series on various topics in Oracle. It is very Helpful and Useful. Now your videos had helped me to get placed in a good MNC company also. I am keep on following your videos. Now I feel confident and motivated in my day to day tasks in office and continuing my Certification as well. Daily I wondered how much of your Time you spend Patiently to create this video. Awesome ! I really appreciate your hard work and Dedication towards yours to achieve this is not a simple Task. From the Bottom of my heart i am saying this "The way you explain a Topic is "Out of This World". God Bless You Siva Sir. Keep Rocking Always. Also Please Help us as usual by Posting New Video as per the Comments. Thanks this is your finishing dialogue at the end of all your videos which is this . ( And Thanks a Lot for reading this comment. Subscribe and Stay Tuned for more comments for me. )
@SivaAcademy
@SivaAcademy 10 ай бұрын
Its my pleasure bro, thank you
@rajeevramakrishnan4624
@rajeevramakrishnan4624 2 жыл бұрын
Thank you Siva for your effort in creating these superb videos. I watched all your 79 videos and attended interview today. Most of the questions from here only. In the intermediate level. Very helpful. I got to know about this from my friend. He also got a job offer two months back.
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Welcome bro, Best wishes 👍👍💐
@adityagopavajjula3563
@adityagopavajjula3563 4 жыл бұрын
Thank you Siva sir for explaining the differences in detail. I haven't heard about the concept of High Water Mark till now. Also, your way of classifying the answer based on the experience level of the candidate is very helpful.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
You're most welcome
@mohammedfarhanm6708
@mohammedfarhanm6708 10 ай бұрын
Hi Siva, Literally you have explained it in a way that even a person who is not interested will get interested in Oracle PL/SQL.
@SivaAcademy
@SivaAcademy 10 ай бұрын
Thank you bro
@mohankrishnavurity4849
@mohankrishnavurity4849 3 жыл бұрын
This tutorial has helped me a lot in getting a good job offer. Very useful tutorial for those who are preparing for PLSQL interviews. Each and every concept is beautifully explained.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Best wishes 💐💐👍👍
@phaneendrareddy4009
@phaneendrareddy4009 2 жыл бұрын
@@SivaAcademy I need Oracle plsql developer course. Could you please provide course.
@prajaktadeshpande8780
@prajaktadeshpande8780 2 жыл бұрын
This video's really helped me alot to get clear my technical rounds, I cleared technical rounds of all three companies where I have applied thanks alot sir🙏
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Wow great, Best wishes
@elanchezhiyanst
@elanchezhiyanst 3 жыл бұрын
I have cleared all my technical interviews and got offer after watching all your videos... Credit goes to you @sivaacademy .. Thank you very much for the video.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Thank you, and wishing you all the best :-)
@elanchezhiyanst
@elanchezhiyanst 3 жыл бұрын
@@SivaAcademy thank you very much sir
@ShahulHameed-zx2zy
@ShahulHameed-zx2zy Жыл бұрын
Happy to understand your valuable videos to get more database concepts , advanced in Oracle. Thanks so much sir
@SivaAcademy
@SivaAcademy Жыл бұрын
Welcome bro
@TienNguyen-fr7we
@TienNguyen-fr7we 2 жыл бұрын
Dear Mr. Siva, just wanted to say that your YT channel is one of the best Oracle channel I have seen so far. Thank you so much for sharing with the Oracle community. BR
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Its my pleasure, thank you so much bro
@sreenivasaraobovanagiri1221
@sreenivasaraobovanagiri1221 4 жыл бұрын
SQL/PLSQL Videos are very useful and one of the best videos that i have seen.Well narrative videos. Thanks you so much. I request you keep posting more videos.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Welcome bro 🙏, please stay tuned for more videos
@ravindrapatil1654
@ravindrapatil1654 3 жыл бұрын
Hi Siva, All your videos are very nice and neatly explained. Thanks for sharing such a useful information for interview preparation. My request for you, can you please upload the videos on table partitioning and performance tuning. In most of the interviews the questions are asked based on these concepts.
@ganeshgalla1088
@ganeshgalla1088 3 жыл бұрын
Hi Siva, DDL trigger will fire for truncate right ? can we say that point ?
@jinnug9759
@jinnug9759 3 күн бұрын
good way of presenting and good contentfor sql plsql thank you for these videos great work
@logeshg4837
@logeshg4837 3 жыл бұрын
Hello siva, You are doing an excellent job for youngsters. keep inspiring us!.. Here i have one que? As you have mention above "no triggers will get invoked" in truncate field right! Using DDL trigger we can attain it right? CREATE or REPLACE TRIGGER AFTER DDL ON SCHEMA ENABLE BEGIN DBMS_OUTPUT.PUT_LINE('TABLE TRUNCATED'); END; / TRUNCATE TABLE ; Just i have shared my understanding here please advise me on this! Thank You!
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Welcome bro, its covered under this video bro, thanks for your comments 💐💐🙏 kzbin.info/www/bejne/innIimhvjdxliKs
@logeshg4837
@logeshg4837 3 жыл бұрын
@@SivaAcademy Thanks for your time bro❤
@SivaAcademy
@SivaAcademy 3 жыл бұрын
My pleasure bro 😊💐🙏
@juliegeorge6227
@juliegeorge6227 Ай бұрын
Thank you very much! Your videos helped me to learn lots of concepts in a short time and helped me to clear interviews. Please keep up the good work.
@SivaAcademy
@SivaAcademy Ай бұрын
Thank you 🙏
@shariquesayeed4
@shariquesayeed4 3 жыл бұрын
thank you so much Siva Ji by your videos I got two big offers, your videos are very crystal clear.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
My pleasure, All the best 🌸🌸🍀🍀💐💐
@vikaskumar-qr5tj
@vikaskumar-qr5tj 2 жыл бұрын
@sharique can you disclose the name of company??
@sunithailapakurthy
@sunithailapakurthy 2 жыл бұрын
Thankyou so much for the very informative play lists. Very clear and brief. I could confidently attend an interview today. Please keep going.
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Welcome bro, Best wishes 💐💐👍
@chsurekha4126
@chsurekha4126 3 жыл бұрын
Sir i got one question on index like if we create index on column of some data type (anything) but while accessing we are using some other data type, will index work.? i tried to simulate the case.. created table of t with column as col number having records 1 to 5000 number then created index on col then queries the table using select st -- it made full table scan even though idx created i have make 3000 records only for number 5 and fetched record 5 -- still index is not used -- it is using full table scan-- so i m failing to simulate the case could you please help me the solution
@kishorekumar4542
@kishorekumar4542 2 жыл бұрын
Hi Sir, Can you pls explain about high level water mark, thankyou in advance.
@SivaAcademy
@SivaAcademy 2 жыл бұрын
As soon as possible, Please stay tuned
@VijayKumar-eq2te
@VijayKumar-eq2te 3 жыл бұрын
sir which book is better for reading sql and plsql for beginners.
@pankajpal9120
@pankajpal9120 3 жыл бұрын
how to check water mark level? suppose if we do delete purge it will delete permanently so the water mark level will reset or not ??
@chsurekha4126
@chsurekha4126 3 жыл бұрын
Sir will you teach informatica/Talend also like this, any paid course exists or any youtube channel already there.? Please let me know
@raginideshpande7015
@raginideshpande7015 4 жыл бұрын
In the explanation of trigger being fired on delete - you used "delete from ;" without any where clause. So this delete statement will delete all records present in the table. So will the trigger be fired only once or it will be fired for each record being deleted?
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Row level trigger get fired for each and every row, whereas statement level trigger gets fired once for statement execution, you can look into this video for further details kzbin.info/www/bejne/hnbJeaivmJxssK8
@thedataengine
@thedataengine 3 жыл бұрын
Will reducing the table space of truncate will help in improving the performance while fetching the data...or how it will be helpful? Could you please explain that as well?
@ananyanandila
@ananyanandila 4 жыл бұрын
Hi . Can anyone tell me a query to get a function name ... I have the package name .. but I need to know which function uses that package
@venkatkrishbattula728
@venkatkrishbattula728 3 жыл бұрын
Hi Siva can you reply me is plsql work on all databases
@siprabehera4680
@siprabehera4680 3 жыл бұрын
Hi Siva sir. Can you please help me in a query. For example In a table we have data for a column value Ram,shyam,Hari Next i am updating record as Ram,Hari Then how we will get to know the record shyam has been deleted. Need help
@SivaAcademy
@SivaAcademy 3 жыл бұрын
is all the comma separated values stored in single column? or each value in one row? for eg "Ram,shyam,Hari" stored in single row? or in three different row?
@bharathipandian45
@bharathipandian45 3 жыл бұрын
Siva, could not get the difference on delete trigger and truncate. We wrote triggers on delete, hence it is fired, we didn't use on truncate triggers. Hence it didn't. How it could be the difference? Could explain me of undo segment?
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Covered with example here on this specific use case, please look into this video kzbin.info/www/bejne/innIimhvjdxliKs
@vivektarab16
@vivektarab16 2 ай бұрын
Start - 0:34 - - 0:30 - Difference b/w Delete and Truncate - Delete is a DML command, white Truncate is a DDL command - For Delete we need to Explicitly do a Commit, otherwise the information will not be committed, so that we can Rollback, If we don't want the change to be committed we can have the option of Rollback in terms of Delete - In Truncate we do not have option to Rollback or Delete because it is an Auto commit Statement and once the statement is issued all the rows will be removed and automatically getting committed. 1:11 - With Delete we can use the Where condition, however with Truncate we cannot use Where condition. All the records of the table will get removed. 1:21 - Delete is bit Slower, because once a informations are deleted there is a option that we may rollback the informations also. So that Oracle will retain the deleted information in the Rollback Segment. So in case if we do a Rollback it will replace the information or it will bring back the information from the Rollback So Delete is bit Slower however Truncate is very fast and incase if you want to delete and insert a huge amount of informations, then better you create and new table, take of backup of the record then just do a Truncate, then you just bring the information from your backup table, so by that it will be very faster also. 2:01 - Difference from Triggers 2:23 - On Delete Trigger 3:29 - On Delete Cascade 4:54 - Demo 6:10 - One more Example
@prathapreddy9618
@prathapreddy9618 2 жыл бұрын
Can you please explain difference between truncate and drop I just know that both are DDL commands.. Thank you
@venkatasubbareddyonteru4581
@venkatasubbareddyonteru4581 5 жыл бұрын
hii siva sir..what is cataloge ? what is the relation between sql and cataloge
@ncsekhar9889
@ncsekhar9889 3 жыл бұрын
Hi siva, i want to joins in sql video...examples and interview question. pls share that link.
@priyanshupathak5606
@priyanshupathak5606 4 жыл бұрын
Hi Siva , I'm developer at Oracle and really love coding in PL/SQL. In one of the interviews I was asked to transpose rows to column without using PIVOT concept. Question was transpose below a 10 40 b 20 50 c 23 null into---> a b c 10 20 23 40 50 null I tried my best searching online using decode or case statement , but no success . Please provide solution for this , it will help many like me. Big fat thumbs up for the effort you are putting in making us achieve our dreams.
@sandeepdwivedi6065
@sandeepdwivedi6065 2 жыл бұрын
You can do this by using case
@nihalbasha5720
@nihalbasha5720 3 жыл бұрын
Hi Sir, Thank you so much for this information. Is very easy to understand. I have a concern on 5th point i.e. with triggers. I believe DDL trigger would be helpful to capture the truncate event. So eventually, triggers could get fired on both delete and truncate statements right. Kindly correct me if I'm wrong. Keep up the good work 😊🤝.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
You are right bro, please look into this video for more details kzbin.info/www/bejne/innIimhvjdxliKs
@nihalbasha5720
@nihalbasha5720 3 жыл бұрын
@@SivaAcademy Thank you for the quick response 😊 and the provided link video was helpful.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Welcome bro
@potlarambabu3527
@potlarambabu3527 5 жыл бұрын
Your giving good explanation.the way of voic also good very important .
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@ram, thanks bro 🙏🙏
@ramasubramanian2177
@ramasubramanian2177 2 жыл бұрын
Really very useful and easy to understand for beginners. Thanks for your effort.
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Welcome bro
@PravinYadav1
@PravinYadav1 3 жыл бұрын
After Truncate the table size is not reducing. same size sowing as after insert. why is this showing same size???? please clear the doubt.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
can you please analyze the table, and gather stats and try again
@sudharanirajasekar3409
@sudharanirajasekar3409 3 ай бұрын
Sir, You did greate job.👍
@sciencemaster4815
@sciencemaster4815 Жыл бұрын
This was a very good video. I appreciate you making these. It helps a lot.
@SivaAcademy
@SivaAcademy Жыл бұрын
Thank you 🙏💐
@etlqalabs5048
@etlqalabs5048 2 жыл бұрын
Nice covered in detailed difference b/w delete and truncate
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Thank you
@mandalaraghavendra6236
@mandalaraghavendra6236 3 жыл бұрын
Hi sir , very good explanation .. I just have a small doubt .. we can use truncate key word in DDL triggers na .. I have seen it some where is this true ??
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Yes, please look into this video kzbin.info/www/bejne/innIimhvjdxliKs
@kamalamthirunavukkarasu8118
@kamalamthirunavukkarasu8118 2 жыл бұрын
Thankyou so much Sir👏🏻Very well explained and Keep Doing the Great work Sir😊Easy to understand and helps very much in my learning Sir👍🏻
@SivaAcademy
@SivaAcademy 2 жыл бұрын
My pleasure, thank you 🙏💐
@amolsonawane6665
@amolsonawane6665 4 жыл бұрын
It is really good videos and nice explanation with example, it is helpful to all level of person Beginner to expert, keep going on
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Thank you 🙏💐
@chsurekha4126
@chsurekha4126 3 жыл бұрын
Hi Sir, All your videos are really helpful, could you please make videos on parititions also can you please let us understand the below 2 questions 1. If index is not working then what should we do? 2. If inner doesnt work what is the best way to get the output -- i mentioned full outer join removing all nulls.. but interviewer asked any other best way? can you please let us know the ans for these 2 questions
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Thank you 💐, will cover in upcoming videos
@VijayKumar-eq2te
@VijayKumar-eq2te 3 жыл бұрын
Sum of sal each department in emp table by programing language. Interview question???
@venubj1269
@venubj1269 3 жыл бұрын
Hi Siva sir, how to reclaim the space after deleting million records? My requirement is I have 15 million records in one table . From that table I need to delete nearly 6 million records. I can do by creating a copy table with the required records and drop the table and rename the copy table to original table but this is risk because it contains constraints, triggers, grants, etc. so I prefer to go for delete. But I want to know is there any option so that post deletion can we reclaim the space?
@Coc_hubba_hub
@Coc_hubba_hub 4 ай бұрын
alter table enable row movement;--> to move the records to make blocks more efficient alter table shrink space command; u can try these....no guarantee...know that you posted long back...but if anyone can take help
@fayasmohamed3713
@fayasmohamed3713 4 жыл бұрын
Sir I need more clarity on on delete cascade n ondelete ser null.these clauses already exists in previous version foreign key constraint,it seems.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Sure, its part of upcoming video list, please stay tuned
@priyankasarkar6600
@priyankasarkar6600 3 жыл бұрын
Awesome sir! You deserve accolades!
@SivaAcademy
@SivaAcademy 3 жыл бұрын
My pleasure 💐
@wassu789
@wassu789 4 жыл бұрын
Hi Siva, What is high level watermark in this context?
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Hi Syed, the maximum the block up to which the data was inserted earlier in a table is the level called high level water mark. This wont get reset in case of delete, whereas it will be reset to initial block in case of truncate.will post a separate video on this topic soon, please stay tuned.
@wakeelsah812
@wakeelsah812 4 жыл бұрын
Best answer and explanation for interview question...Thanks a ton Siva sir.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
It's my pleasure,Thank you so much :-)
@naimuddinsiddiqui9249
@naimuddinsiddiqui9249 Жыл бұрын
Hi developers, I am preparing for SQL Interviews Is it worthy to follow this playlist I am bit confuse because there is many Oracles playlist in this channel like 12C, 18C I am a nob person in this SQL or Oracle. Any guidance or suggestion would be Highly appreciable Thanks !
@SivaAcademy
@SivaAcademy Жыл бұрын
You can pick any video in interview questions list, however go through in the same order
@ramramaraju2221
@ramramaraju2221 5 жыл бұрын
When there is ddl (before truncate) trigger when you perform truncate this trigger might fire right... Kindly correct me if I am wrong
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@Ramaraju, Yes, your understanding is correct.
@bharathipandian45
@bharathipandian45 5 жыл бұрын
Hi siva, then triggers can be fired on both ddl and dml. It wouldn't be the difference here, am I right?
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@Barathi, explained here kzbin.info/www/bejne/innIimhvjdxliKs Please look into this video for details on ddl and DML trigger on delete VS truncate
@odiboufuoma3659
@odiboufuoma3659 3 жыл бұрын
please i have senior IT DEVELOPER(PL SQL) coming up. please what are likely tecnical and scenario question to be ask?
@SivaAcademy
@SivaAcademy 3 жыл бұрын
This video series has 60+ videos, and planning to add more, please stay tuned for more questions. Scenario based SQL questions are covered in another playlist
@vinayakavini5334
@vinayakavini5334 3 жыл бұрын
Very good explanation and useful. Please can you explain high level watermark?
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Sure please stay tuned
@abhisheknegi8053
@abhisheknegi8053 3 жыл бұрын
Hi Siva i have noticed in Plsql collection series the multiset operator video you have uploaded twice video no 9 and video no 10 are same
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Thank you for letting me know, removed the last duplicate
@vipul7010
@vipul7010 4 жыл бұрын
Nice video.... But triggers do get fired for truncate also... You just have to create a DDL trigger.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Thanks, Yeah, That i covered in this video kzbin.info/www/bejne/innIimhvjdxliKs
@swapnils.s.8855
@swapnils.s.8855 2 жыл бұрын
Sir, Truncate can be rollbacked. Please Check ....
@poornimakp9835
@poornimakp9835 4 жыл бұрын
Please could u explain , How to separate negative numbers and positive numbers in SQL?
@SivaAcademy
@SivaAcademy 4 жыл бұрын
yes, you can use either sign function, or case statement in sql
@Lidagholizadeh369
@Lidagholizadeh369 Жыл бұрын
Thank you so much for your videos and good explanations
@SivaAcademy
@SivaAcademy Жыл бұрын
Welcome 🙏🙏💐💐
@sumanpatibandla1559
@sumanpatibandla1559 3 жыл бұрын
Hi Siva sir, Actually I am a M.com student But I am interesting to learn Oracle dba. As a m.com student oracle dba is ok for me.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
As per me, qualification doesn't matter, as far as you have interest and can spend enough time for practice, you can always learn, all the best 👍💐
@vijayarajan2599
@vijayarajan2599 3 жыл бұрын
Hi Sive, Can you please attach the example script location for all the videos.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
sure, for upcoming videos
@vivektarab16
@vivektarab16 2 ай бұрын
Start - 0:34 - - 0:30 - Difference b/w Delete and Truncate 0:53 - So we can go and Rollback if we do not want the change to be committed - Delete is a DML command, white Truncate is a DDL command 0:59 - For Delete we need to Explicitly do a Commit, otherwise the information will not be committed, so that we can Rollback, If we don't want the change to be committed we can have the option of Rollback in terms of Delete - In Truncate we do not have option to Rollback or Delete because it is an Auto commit Statement and once the statement is issued all the rows will be removed and automatically getting committed. 1:11 - With Delete we can use the Where condition, however with Truncate we cannot use Where condition. All the records of the table will get removed. 1:21 - Delete is bit Slower, because once a informations are deleted there is a option that we may rollback the informations also. So that Oracle will retain the deleted information in the Rollback Segment. So in case if we do a Rollback it will replace the information or it will bring back the information from the Rollback So Delete is bit Slower however Truncate is very fast and incase if you want to delete and insert a huge amount of informations, then better you create and new table, take of backup of the record then just do a Truncate, then you just bring the information from your backup table, so by that it will be very faster also. 1:32 - Oracle will retain 1:47 - In Case if you want to Delete and Insert 2:01 - Difference from Triggers 2:22 - If there is a On Delete Trigger - Whenever we do a delete Statement this Trigger will get fired However Truncate will not fire any Triggers Delete will not reclaim the space, once the data from the table is deleted and if you and check the size of the table, there will not be any difference However in case of Truncate once the informations are removed from the table, and when you check the size of the Table, it would have got reduced. There is concept of High level watermark High level watermark will be reset in case of Truncate where as in case of Delete High level water mark will not be resetted, 3:29 - On Delete Cascade - A new feature has been introduced from 12c onwards where we can give the " On Delete Cascade Keyword " as part of the table definition. So when we will give the On Delete cascade keyword as part of Table as part of table emersion - This is mainly for the Parent Child Relationship - Foreign key relationsp, So whenever we go and delete the record from parent table automatically the child records will get deleted in case it is set as " On Delete cascade " The same is applicable for Truncate, we can Truncate the parent table and we can explicitly say the keyword called CASCADE, so that the Child tables will get automatically truncated provided the table is created with the On Delete Cascade Keyword 4:54 - Demo 6:10 - One more Example
@udbhavdwivedi410
@udbhavdwivedi410 2 жыл бұрын
Can you explain how triggers are not invoked when using truncate??
@udbhavdwivedi410
@udbhavdwivedi410 2 жыл бұрын
You have created a DML Trigger and truncating the table, so no trigger got fired. if we create a DDL trigger, will it work?
@SivaAcademy
@SivaAcademy 2 жыл бұрын
yes, DDL trigger will work, Please look into this video kzbin.info/www/bejne/innIimhvjdxliKs
@martinsuresh5048
@martinsuresh5048 6 жыл бұрын
very helpful information hatsoff sir
@jithendrareddyambati3985
@jithendrareddyambati3985 4 жыл бұрын
Can i know for which command the structure remains same??
@SivaAcademy
@SivaAcademy 4 жыл бұрын
for both truncate, and delete, the structure of the table remains the same.....Only Alter command can change the structure of table
@subbaraogaddale
@subbaraogaddale Ай бұрын
what is hight level water mark,Can u pls explain
@SivaAcademy
@SivaAcademy Ай бұрын
Sure, please stay tuned, will cover in upcoming videos
@sujaa1000
@sujaa1000 4 жыл бұрын
Hi Siva, could you please make video for > partitioning and types of partitioning. > Facts and Dimensions Regards, Sujaa
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Sure, Please stay tuned
@Truthseeker-kc8rd
@Truthseeker-kc8rd 2 жыл бұрын
I immediately subscribed. Thanks for the great content.
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Thank you
@RohitSharma-cw7lk
@RohitSharma-cw7lk 3 жыл бұрын
Hi Sir, can you plz add videos related to all DBMS packages like DBMS_OUTPUT, DBMS_ERRLOG, etc... If already added plz share the link. And thanks a lot sir for these superb videos.
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Welcome bro, sure please stay tuned
@RohitSharma-cw7lk
@RohitSharma-cw7lk 3 жыл бұрын
@@SivaAcademy Hi Sir, still waiting for the videos on DBMS package.
@MsAmma1
@MsAmma1 5 жыл бұрын
Thank you very much for the playlist. All videos are very good.
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@Prashanth, thanks for your comments bro.
@krishnapadarthi4377
@krishnapadarthi4377 4 жыл бұрын
Hi Siva, It is very good explanation for all concepts you have posted to till date. can you help to post partition table concepts and materialized views concepts as well.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Sure, Please stay tuned
@krishnapadarthi4377
@krishnapadarthi4377 4 жыл бұрын
sure
@kumark2579
@kumark2579 2 жыл бұрын
High Level Water mark means ???
@vivektarab16
@vivektarab16 2 ай бұрын
Start 0:30 - Difference b/w Delete and Truncate
@yambay
@yambay 4 жыл бұрын
Thanks a lot. This was really useful information
@amitlondhe3651
@amitlondhe3651 2 жыл бұрын
Very nice explanation sir👍👍
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Welcome bro
@aratipatil8689
@aratipatil8689 4 жыл бұрын
Sir , please make video on different between versions like 11g , 12c , 19c
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Already the new feature videos are posted with respect to each version, seperate playlist for each version is available, however i try to post overall difference across the version, please stay tuned.
@abhisheknegi8053
@abhisheknegi8053 3 жыл бұрын
Could you please make some videos for dynamic Plsql
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Sure, please stay tuned
@ajimsayyad7006
@ajimsayyad7006 3 жыл бұрын
What is mean by high-level watermark ?
@SivaAcademy
@SivaAcademy 3 жыл бұрын
will be covering soon
@shaheenshaikh6701
@shaheenshaikh6701 5 жыл бұрын
Sir plz make video on schema objects n whts its use
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@Shaheen, sure, Please stay tuned.
@aishwaryaalte3698
@aishwaryaalte3698 2 жыл бұрын
What is mean by High level watermark
@fayasmohamed3713
@fayasmohamed3713 4 жыл бұрын
Please give us more information on high level water mark
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Sure , please stay tuned, will cover in upcoming videos
@deepikapolisetty9057
@deepikapolisetty9057 5 жыл бұрын
Hi Sir, This video is good. Can you please post a video on Highlevel Water Mark and can you please tell me why to update the data_dictionary table and use of it. Thanks
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Thanks for your comment,Sure, Please stay tuned. will post on HWM soon
@potlarambabu3527
@potlarambabu3527 5 жыл бұрын
Hi bro. I am like a your brother. I am asking you ,Can you make MVIEW AND ALL REFRESH Usage and also Partitions and types of particition and
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@ram,sure I will post videos on mviews and partitions
@aravindrajendran581
@aravindrajendran581 6 жыл бұрын
Really superbbbbbb.. keep it up ... subscribed .. waiting for more videos..
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Thanks Aravind, i have posted more than 16 questions in this series itself, will be posting more....you can let me know if you are looking for any specific question, i can add as part of upcoming video. Thanks again for your comment. :-)
@parthibankumar1962
@parthibankumar1962 2 жыл бұрын
A samll update on the DDL Trigger concpet . DML Triggers will not be fiered on Truncate but DDL triggers on schema leavel would be fiered.
@SivaAcademy
@SivaAcademy 2 жыл бұрын
you are right bro
@ronaldmourant4343
@ronaldmourant4343 3 жыл бұрын
Hi sir, need a file of these questions. Thanks in advance
@Pras2winma
@Pras2winma 3 жыл бұрын
Thank u somuch ........very helpful
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Welcome
@juno7893
@juno7893 4 жыл бұрын
Very good explanation. Thank you.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Thank you
@tarunmahajan4050
@tarunmahajan4050 3 жыл бұрын
Hi Sir, Please make a video on partitioning tables
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Sure bro, please stay tuned
@tarunmahajan4050
@tarunmahajan4050 3 жыл бұрын
@@SivaAcademy one more request...please make video on hierarchal queries and REGEXP
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Yes bro 👍👍
@bharathipandian45
@bharathipandian45 5 жыл бұрын
Please explain what is high water mark
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@bharathi, yeah sure. I will post a video soon
@HariHaran-zy6fk
@HariHaran-zy6fk Жыл бұрын
Next level ❤❤❤❤❤❤
@SivaAcademy
@SivaAcademy Жыл бұрын
Thank you
@SudhirBhajnawale
@SudhirBhajnawale 5 жыл бұрын
Well explained Sir ... Thanks a lot :-)
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@Sudir, thanks for your comments bro 🙏
@dineshkumar-vp9dm
@dineshkumar-vp9dm 4 жыл бұрын
What is different between for and forall clause
@SivaAcademy
@SivaAcademy 4 жыл бұрын
sure, please stay tuned, will be posting soon
@kumark2579
@kumark2579 2 жыл бұрын
You have not explained what is HIGH LEVEL WATERMARK
@kumark2579
@kumark2579 Жыл бұрын
Please reply
@SivaAcademy
@SivaAcademy Жыл бұрын
Sure bro, please stay tuned, will cover in upcoming videos
@rameshyadav7997
@rameshyadav7997 5 ай бұрын
​@SivaAcademy If you have recorded any video on this please share.
@sumansauravsatpathy
@sumansauravsatpathy 4 жыл бұрын
Nice way hat's up sir.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Thank you 🙏
@telagarapuashoksaichakrava3600
@telagarapuashoksaichakrava3600 2 жыл бұрын
Brother I already asked u about bulk exception u promised me that u will provide it with in a week but it is already more than 10 days please provide bulk exception please 🙏🙏🙏🙏🙏🙏🙏🙏
@telagarapuashoksaichakrava3600
@telagarapuashoksaichakrava3600 2 жыл бұрын
Please provide it me bro
@SivaAcademy
@SivaAcademy 2 жыл бұрын
Really sorry for late, content is ready bro, will try to post in a day or two, please stay tuned
@poornimakp9835
@poornimakp9835 4 жыл бұрын
Very nice video sir
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Thank you 💐
Chapter 5 Rheology and hydraulics
1:48:52
Mud Meeting
Рет қаралды 8
Я сделала самое маленькое в мире мороженое!
00:43
Кушать Хочу
Рет қаралды 4,5 МЛН
黑的奸计得逞 #古风
00:24
Black and white double fury
Рет қаралды 14 МЛН
Бенчик, пора купаться! 🛁 #бенчик #арти #симбочка
00:34
Симбочка Пимпочка
Рет қаралды 3,2 МЛН
Oracle Interview Question oracle index related questions
14:11
Siva Academy
Рет қаралды 147 М.
Oracle PL SQL interview question CURSOR Vs COLLECTION
17:50
Siva Academy
Рет қаралды 57 М.
Oracle PL SQL interview question | SQL to Delete duplicate records
17:27
oracle interview question oracle index and types of index
14:41
Siva Academy
Рет қаралды 101 М.
Я сделала самое маленькое в мире мороженое!
00:43
Кушать Хочу
Рет қаралды 4,5 МЛН