One of the best lectures that i have seen in youtube for Database developers.... Thank you very much.....
@SivaAcademy6 жыл бұрын
Thanks for your comments Raju :-)
@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 !
@amanpandey49073 жыл бұрын
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. Жыл бұрын
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. )
@SivaAcademy10 ай бұрын
Its my pleasure bro, thank you
@rajeevramakrishnan46242 жыл бұрын
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.
@SivaAcademy2 жыл бұрын
Welcome bro, Best wishes 👍👍💐
@adityagopavajjula35634 жыл бұрын
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.
@SivaAcademy4 жыл бұрын
You're most welcome
@mohammedfarhanm670810 ай бұрын
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.
@SivaAcademy10 ай бұрын
Thank you bro
@mohankrishnavurity48493 жыл бұрын
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.
@SivaAcademy3 жыл бұрын
Best wishes 💐💐👍👍
@phaneendrareddy40092 жыл бұрын
@@SivaAcademy I need Oracle plsql developer course. Could you please provide course.
@prajaktadeshpande87802 жыл бұрын
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🙏
@SivaAcademy2 жыл бұрын
Wow great, Best wishes
@elanchezhiyanst3 жыл бұрын
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.
@SivaAcademy3 жыл бұрын
Thank you, and wishing you all the best :-)
@elanchezhiyanst3 жыл бұрын
@@SivaAcademy thank you very much sir
@ShahulHameed-zx2zy Жыл бұрын
Happy to understand your valuable videos to get more database concepts , advanced in Oracle. Thanks so much sir
@SivaAcademy Жыл бұрын
Welcome bro
@TienNguyen-fr7we2 жыл бұрын
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
@SivaAcademy2 жыл бұрын
Its my pleasure, thank you so much bro
@sreenivasaraobovanagiri12214 жыл бұрын
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.
@SivaAcademy4 жыл бұрын
Welcome bro 🙏, please stay tuned for more videos
@ravindrapatil16543 жыл бұрын
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.
@ganeshgalla10883 жыл бұрын
Hi Siva, DDL trigger will fire for truncate right ? can we say that point ?
@jinnug97593 күн бұрын
good way of presenting and good contentfor sql plsql thank you for these videos great work
@logeshg48373 жыл бұрын
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!
@SivaAcademy3 жыл бұрын
Welcome bro, its covered under this video bro, thanks for your comments 💐💐🙏 kzbin.info/www/bejne/innIimhvjdxliKs
@logeshg48373 жыл бұрын
@@SivaAcademy Thanks for your time bro❤
@SivaAcademy3 жыл бұрын
My pleasure bro 😊💐🙏
@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Ай бұрын
Thank you 🙏
@shariquesayeed43 жыл бұрын
thank you so much Siva Ji by your videos I got two big offers, your videos are very crystal clear.
@SivaAcademy3 жыл бұрын
My pleasure, All the best 🌸🌸🍀🍀💐💐
@vikaskumar-qr5tj2 жыл бұрын
@sharique can you disclose the name of company??
@sunithailapakurthy2 жыл бұрын
Thankyou so much for the very informative play lists. Very clear and brief. I could confidently attend an interview today. Please keep going.
@SivaAcademy2 жыл бұрын
Welcome bro, Best wishes 💐💐👍
@chsurekha41263 жыл бұрын
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
@kishorekumar45422 жыл бұрын
Hi Sir, Can you pls explain about high level water mark, thankyou in advance.
@SivaAcademy2 жыл бұрын
As soon as possible, Please stay tuned
@VijayKumar-eq2te3 жыл бұрын
sir which book is better for reading sql and plsql for beginners.
@pankajpal91203 жыл бұрын
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 ??
@chsurekha41263 жыл бұрын
Sir will you teach informatica/Talend also like this, any paid course exists or any youtube channel already there.? Please let me know
@raginideshpande70154 жыл бұрын
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?
@SivaAcademy4 жыл бұрын
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
@thedataengine3 жыл бұрын
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?
@ananyanandila4 жыл бұрын
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
@venkatkrishbattula7283 жыл бұрын
Hi Siva can you reply me is plsql work on all databases
@siprabehera46803 жыл бұрын
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
@SivaAcademy3 жыл бұрын
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?
@bharathipandian453 жыл бұрын
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?
@SivaAcademy3 жыл бұрын
Covered with example here on this specific use case, please look into this video kzbin.info/www/bejne/innIimhvjdxliKs
@vivektarab162 ай бұрын
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
@prathapreddy96182 жыл бұрын
Can you please explain difference between truncate and drop I just know that both are DDL commands.. Thank you
@venkatasubbareddyonteru45815 жыл бұрын
hii siva sir..what is cataloge ? what is the relation between sql and cataloge
@ncsekhar98893 жыл бұрын
Hi siva, i want to joins in sql video...examples and interview question. pls share that link.
@priyanshupathak56064 жыл бұрын
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.
@sandeepdwivedi60652 жыл бұрын
You can do this by using case
@nihalbasha57203 жыл бұрын
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 😊🤝.
@SivaAcademy3 жыл бұрын
You are right bro, please look into this video for more details kzbin.info/www/bejne/innIimhvjdxliKs
@nihalbasha57203 жыл бұрын
@@SivaAcademy Thank you for the quick response 😊 and the provided link video was helpful.
@SivaAcademy3 жыл бұрын
Welcome bro
@potlarambabu35275 жыл бұрын
Your giving good explanation.the way of voic also good very important .
@SivaAcademy5 жыл бұрын
@ram, thanks bro 🙏🙏
@ramasubramanian21772 жыл бұрын
Really very useful and easy to understand for beginners. Thanks for your effort.
@SivaAcademy2 жыл бұрын
Welcome bro
@PravinYadav13 жыл бұрын
After Truncate the table size is not reducing. same size sowing as after insert. why is this showing same size???? please clear the doubt.
@SivaAcademy3 жыл бұрын
can you please analyze the table, and gather stats and try again
@sudharanirajasekar34093 ай бұрын
Sir, You did greate job.👍
@sciencemaster4815 Жыл бұрын
This was a very good video. I appreciate you making these. It helps a lot.
@SivaAcademy Жыл бұрын
Thank you 🙏💐
@etlqalabs50482 жыл бұрын
Nice covered in detailed difference b/w delete and truncate
@SivaAcademy2 жыл бұрын
Thank you
@mandalaraghavendra62363 жыл бұрын
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 ??
@SivaAcademy3 жыл бұрын
Yes, please look into this video kzbin.info/www/bejne/innIimhvjdxliKs
@kamalamthirunavukkarasu81182 жыл бұрын
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👍🏻
@SivaAcademy2 жыл бұрын
My pleasure, thank you 🙏💐
@amolsonawane66654 жыл бұрын
It is really good videos and nice explanation with example, it is helpful to all level of person Beginner to expert, keep going on
@SivaAcademy4 жыл бұрын
Thank you 🙏💐
@chsurekha41263 жыл бұрын
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
@SivaAcademy3 жыл бұрын
Thank you 💐, will cover in upcoming videos
@VijayKumar-eq2te3 жыл бұрын
Sum of sal each department in emp table by programing language. Interview question???
@venubj12693 жыл бұрын
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_hub4 ай бұрын
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
@fayasmohamed37134 жыл бұрын
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.
@SivaAcademy4 жыл бұрын
Sure, its part of upcoming video list, please stay tuned
@priyankasarkar66003 жыл бұрын
Awesome sir! You deserve accolades!
@SivaAcademy3 жыл бұрын
My pleasure 💐
@wassu7894 жыл бұрын
Hi Siva, What is high level watermark in this context?
@SivaAcademy4 жыл бұрын
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.
@wakeelsah8124 жыл бұрын
Best answer and explanation for interview question...Thanks a ton Siva sir.
@SivaAcademy4 жыл бұрын
It's my pleasure,Thank you so much :-)
@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 Жыл бұрын
You can pick any video in interview questions list, however go through in the same order
@ramramaraju22215 жыл бұрын
When there is ddl (before truncate) trigger when you perform truncate this trigger might fire right... Kindly correct me if I am wrong
@SivaAcademy5 жыл бұрын
@Ramaraju, Yes, your understanding is correct.
@bharathipandian455 жыл бұрын
Hi siva, then triggers can be fired on both ddl and dml. It wouldn't be the difference here, am I right?
@SivaAcademy5 жыл бұрын
@Barathi, explained here kzbin.info/www/bejne/innIimhvjdxliKs Please look into this video for details on ddl and DML trigger on delete VS truncate
@odiboufuoma36593 жыл бұрын
please i have senior IT DEVELOPER(PL SQL) coming up. please what are likely tecnical and scenario question to be ask?
@SivaAcademy3 жыл бұрын
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
@vinayakavini53343 жыл бұрын
Very good explanation and useful. Please can you explain high level watermark?
@SivaAcademy3 жыл бұрын
Sure please stay tuned
@abhisheknegi80533 жыл бұрын
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
@SivaAcademy3 жыл бұрын
Thank you for letting me know, removed the last duplicate
@vipul70104 жыл бұрын
Nice video.... But triggers do get fired for truncate also... You just have to create a DDL trigger.
@SivaAcademy4 жыл бұрын
Thanks, Yeah, That i covered in this video kzbin.info/www/bejne/innIimhvjdxliKs
@swapnils.s.88552 жыл бұрын
Sir, Truncate can be rollbacked. Please Check ....
@poornimakp98354 жыл бұрын
Please could u explain , How to separate negative numbers and positive numbers in SQL?
@SivaAcademy4 жыл бұрын
yes, you can use either sign function, or case statement in sql
@Lidagholizadeh369 Жыл бұрын
Thank you so much for your videos and good explanations
@SivaAcademy Жыл бұрын
Welcome 🙏🙏💐💐
@sumanpatibandla15593 жыл бұрын
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.
@SivaAcademy3 жыл бұрын
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 👍💐
@vijayarajan25993 жыл бұрын
Hi Sive, Can you please attach the example script location for all the videos.
@SivaAcademy3 жыл бұрын
sure, for upcoming videos
@vivektarab162 ай бұрын
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
@udbhavdwivedi4102 жыл бұрын
Can you explain how triggers are not invoked when using truncate??
@udbhavdwivedi4102 жыл бұрын
You have created a DML Trigger and truncating the table, so no trigger got fired. if we create a DDL trigger, will it work?
@SivaAcademy2 жыл бұрын
yes, DDL trigger will work, Please look into this video kzbin.info/www/bejne/innIimhvjdxliKs
@martinsuresh50486 жыл бұрын
very helpful information hatsoff sir
@jithendrareddyambati39854 жыл бұрын
Can i know for which command the structure remains same??
@SivaAcademy4 жыл бұрын
for both truncate, and delete, the structure of the table remains the same.....Only Alter command can change the structure of table
@subbaraogaddaleАй бұрын
what is hight level water mark,Can u pls explain
@SivaAcademyАй бұрын
Sure, please stay tuned, will cover in upcoming videos
@sujaa10004 жыл бұрын
Hi Siva, could you please make video for > partitioning and types of partitioning. > Facts and Dimensions Regards, Sujaa
@SivaAcademy4 жыл бұрын
Sure, Please stay tuned
@Truthseeker-kc8rd2 жыл бұрын
I immediately subscribed. Thanks for the great content.
@SivaAcademy2 жыл бұрын
Thank you
@RohitSharma-cw7lk3 жыл бұрын
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.
@SivaAcademy3 жыл бұрын
Welcome bro, sure please stay tuned
@RohitSharma-cw7lk3 жыл бұрын
@@SivaAcademy Hi Sir, still waiting for the videos on DBMS package.
@MsAmma15 жыл бұрын
Thank you very much for the playlist. All videos are very good.
@SivaAcademy5 жыл бұрын
@Prashanth, thanks for your comments bro.
@krishnapadarthi43774 жыл бұрын
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.
@SivaAcademy4 жыл бұрын
Sure, Please stay tuned
@krishnapadarthi43774 жыл бұрын
sure
@kumark25792 жыл бұрын
High Level Water mark means ???
@vivektarab162 ай бұрын
Start 0:30 - Difference b/w Delete and Truncate
@yambay4 жыл бұрын
Thanks a lot. This was really useful information
@amitlondhe36512 жыл бұрын
Very nice explanation sir👍👍
@SivaAcademy2 жыл бұрын
Welcome bro
@aratipatil86894 жыл бұрын
Sir , please make video on different between versions like 11g , 12c , 19c
@SivaAcademy4 жыл бұрын
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.
@abhisheknegi80533 жыл бұрын
Could you please make some videos for dynamic Plsql
@SivaAcademy3 жыл бұрын
Sure, please stay tuned
@ajimsayyad70063 жыл бұрын
What is mean by high-level watermark ?
@SivaAcademy3 жыл бұрын
will be covering soon
@shaheenshaikh67015 жыл бұрын
Sir plz make video on schema objects n whts its use
@SivaAcademy5 жыл бұрын
@Shaheen, sure, Please stay tuned.
@aishwaryaalte36982 жыл бұрын
What is mean by High level watermark
@fayasmohamed37134 жыл бұрын
Please give us more information on high level water mark
@SivaAcademy4 жыл бұрын
Sure , please stay tuned, will cover in upcoming videos
@deepikapolisetty90575 жыл бұрын
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
@SivaAcademy4 жыл бұрын
Thanks for your comment,Sure, Please stay tuned. will post on HWM soon
@potlarambabu35275 жыл бұрын
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
@SivaAcademy5 жыл бұрын
@ram,sure I will post videos on mviews and partitions
@aravindrajendran5816 жыл бұрын
Really superbbbbbb.. keep it up ... subscribed .. waiting for more videos..
@SivaAcademy6 жыл бұрын
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. :-)
@parthibankumar19622 жыл бұрын
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.
@SivaAcademy2 жыл бұрын
you are right bro
@ronaldmourant43433 жыл бұрын
Hi sir, need a file of these questions. Thanks in advance
@Pras2winma3 жыл бұрын
Thank u somuch ........very helpful
@SivaAcademy3 жыл бұрын
Welcome
@juno78934 жыл бұрын
Very good explanation. Thank you.
@SivaAcademy4 жыл бұрын
Thank you
@tarunmahajan40503 жыл бұрын
Hi Sir, Please make a video on partitioning tables
@SivaAcademy3 жыл бұрын
Sure bro, please stay tuned
@tarunmahajan40503 жыл бұрын
@@SivaAcademy one more request...please make video on hierarchal queries and REGEXP
@SivaAcademy3 жыл бұрын
Yes bro 👍👍
@bharathipandian455 жыл бұрын
Please explain what is high water mark
@SivaAcademy5 жыл бұрын
@bharathi, yeah sure. I will post a video soon
@HariHaran-zy6fk Жыл бұрын
Next level ❤❤❤❤❤❤
@SivaAcademy Жыл бұрын
Thank you
@SudhirBhajnawale5 жыл бұрын
Well explained Sir ... Thanks a lot :-)
@SivaAcademy5 жыл бұрын
@Sudir, thanks for your comments bro 🙏
@dineshkumar-vp9dm4 жыл бұрын
What is different between for and forall clause
@SivaAcademy4 жыл бұрын
sure, please stay tuned, will be posting soon
@kumark25792 жыл бұрын
You have not explained what is HIGH LEVEL WATERMARK
@kumark2579 Жыл бұрын
Please reply
@SivaAcademy Жыл бұрын
Sure bro, please stay tuned, will cover in upcoming videos
@rameshyadav79975 ай бұрын
@SivaAcademy If you have recorded any video on this please share.
@sumansauravsatpathy4 жыл бұрын
Nice way hat's up sir.
@SivaAcademy4 жыл бұрын
Thank you 🙏
@telagarapuashoksaichakrava36002 жыл бұрын
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 🙏🙏🙏🙏🙏🙏🙏🙏
@telagarapuashoksaichakrava36002 жыл бұрын
Please provide it me bro
@SivaAcademy2 жыл бұрын
Really sorry for late, content is ready bro, will try to post in a day or two, please stay tuned