TCL Command in SQL | Oracle Database
HTML-код
- Опубликовано: 18 июл 2021
- Oracle Database Full Course 👇👇
• Oracle Database | SQL
Don't forget to tag our Channel...!
#oracledatabase
#oracle
#sql
#sqltclcommand
#tclcommands
#oraclesql
#oracle11g
#ask4help
#LearnCoding
|| Content ||
1. voice 🔊 :- akhilesh
2. writer ✍ :- ankush
Thank You
👌👌👌
Very interactive and nice explaination Sir.Most doubts regarding TCL commands are cleared 👍☺️
Brother your explanation is truly amazing, there are lots of videos on commit, rollback but there is no explanation like you. You cleared my all doubts Thank you so much
Your teaching style is best sir, I really understand all consept
Bro, i love your videos just because of you teaching method, thank you soo much🙂🙂.
Beautiful explanation. Thank you very much
sabse jyada darr jis language se lagta tha vo kam ho rha he.. aur confidence lag rhe he sql command krne me... thank you bhai.. aap jo bhi ho bhagwan aapko lambi umar de..khush rakhe... aapki sab eechha puri ho... yahi prarthana he..... thank you once again...
🤗
Apka pura java playlist dekha
Thanks sir
I'm waiting for next video......
To the point information not like other youtuber those who always beat about the bash, hats off to teaching style :)
👌
Bahut acche se samjaya sir ji aap ne 🙏
Thank you so much sir for helping me in exams ...😊
Nice explanation sir thank u so much 😊
Your tutorials are really best
best lecture ever❣️
Well explained, thak you!
Thanks guru g
Bhagban aapko lambi umar de
Aur aap hmesha khus rahe
Good Explanation 👌
Thank you so much sir🙏🙏🙏
Thank U Sir-G 🙏🙏
Tqsm sir its really helpfull for me ..gbu
Thank u for u r information.....
Javascript ke upar video banado sir.. Apka padhane ka way Acha laga.. I hope js ke upar koi video banaoge ap.
Very informative video sir, you have explained everything really well. Thanks a ton!
Best explaination👏
Mindblowing explaination
Aap bahut aage jaao sirr❤❤❤❤
Thanks a lot sir 🎉❤🎉❤🎉❤🎉❤
Toward' One Million soon...…!
First view...❤️
Thank you sir.
Thank you so much 🙏🙏
Thank you so much sir
thanks sir nice explanation
Thank You Sir
Love you vai
Nice explanation
Thx very much sir
Excellent
thanks man!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Your videos helpful to me please make a for how connect sqlplus to Oracle database
🙏👌🏼💞
Saabaashh
great work sir
❤
Vaia bojlamna ato sondor kora bojan,tobuo like view hoi na kano...??
Thanks sir 🙏🙏🙏🙏
Nice😊
Sir please make video on Recovery Techniques for second year computer diploma students
🙏
Super
Nice bro
from Nepal
sir please ms office ki sari type kardo
Sir undo ke liye to apne rollback use kar lete hai but agar redo karna hoto to uske kaunsi query pass karenge?
If savepoint and rollback are not working, it means your software has auto commit enabled which saves your work automatically and you won't require to run COMMIT function repeatedly. Simply "set AUTOCOMMIT = 0" to disable auto commit function. "set AUTOCOMMIT = 1" again to enable auto commit function so that you won't loose your work.
Qq
Thank you soo much sir🙏
Ok will try
by defaultily auto commit is turned off,if you are enabled you need to turn off except no need to do it
One question..
Please answer me
Commit krne ke baad jb data ko update krte hai to wo server me store nhi hota hai... But jb ek row ko delete krte hai or fir database ko close krte hai....to kya! Jo data commit krne ke baad show kr rha tha wo fir whi show krega? Ya fir deleted data show nhi krega?
Vk 😍👑
Sir data structure in java padha dijye❤️❤️
Sr cursor package function trigger in oracle ....vo sab ke bhi video bnao na sr please
brother jaisa apna btaya
>SAVEPOINT A 10Record
>savepoint B 20Record
>Savepoint C 30Record
ab mai rollback karta hu to C par jaunga fir rollback karta hu to B par jaunga lakin C sa dairect A par
jata hu to mera B & C Record Delete ho jayga
mai phla C save point par jata hu fir B par fir A par to mera Record safe i mean Save rahega
bro your video gone a help me in my STUDY i need this SQL command line tool link
Arey bhai Notes vi de diya karo yr plz ..
Commit ,rollback and savepoint
syntax of revoke and Grant in DCL plz
in my case rollback command not working. please help..!!
Can you give me the pdf link of your notes sir? please
Sir please c#.net pr MCQ banaiye na
Rollback delete ke bad kaise kam krne lg gya jbki vo bhi to commit data tha
*If we use commit; after save point c then rollback to c; possible*
no....commit is a permanent change.rollback wont work for committed operations.
sir where to get these handwritten notes
can you please provide the notes
Sir is lefty🤨
Sir... agr hume savepoints C ke sirf adhe hi records dekhne hai.... ya sirf under best of 200 ke records dekhne hai... aur vo savepoints B me adhe hi kul char records me se sirf 2 records tk hi best of 200 ke records hai... tb hum query kese fire krenge
Conditional query apply krni hogi
@@LearnCodingOfficial ok sir thank you
Bro how to bring the data we created after truncating the table?
here you can do rollback
commit karne ke baad mujhe permanent data delete karna hai toh konsa query use karna ka hai?
Truncate then commit
Yr views.5000 hm or sub sirf 175 😳😳
Kya rollback table ko drop krne k baad bhi work krega ?
no it wont work...drop is permanent.
@@asharaju4169 exams over ho gye bhai kaash pehle bataya hota but anyways ... thanks 🥲
English
Sir ye DBMS hi hai kya
What do you think??
@@ScareCrowFC sorry that mistakely happened my question is this is not there in my book that's why I was asked!
bro maine aapko 1.5 saal se subscribe kiya tha bahot respect tha aapke liye mere dil main but aaj wo sab khatam ho gaya kyun ki aapne Mere bhagwan Rohit sharma ko Table main add kar rahe the aur delete kar rahe the aur baad main to add hi nahin kiya aur unki bejjati ki so isiliye maine unsubscribe kiya aur doston ke phone se bhi kar diya main jaanta hun ki isse apka kuch bigde ga nahin par jo respect tha wo ab nahin raha ab jaa raha hun GATE SMASHERS se videos dekhunga
We also love and support our captain RohitMan sharma and King kohli Too❤️. Aur maine kisi ka insult nhi Kiya h
@@LearnCodingOfficialSir don't take serious , ye log wo hai free me khaana khaake bolte hai maja ni aya .
Oye dhoni ki rank 1 kar
Sir DCL kaha geyaa
Jb privileges aayega tb complete kra denge
Ok sir
@@LearnCodingOfficial Sir kab aayega?
Thanks sir