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
    👌👌👌

Комментарии • 103

  • @shubhangimahajan5089
    @shubhangimahajan5089 Год назад +11

    Very interactive and nice explaination Sir.Most doubts regarding TCL commands are cleared 👍☺️

  • @gourabkarmakar2573
    @gourabkarmakar2573 3 месяца назад +1

    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

  • @kartikathakare2789
    @kartikathakare2789 2 года назад +5

    Your teaching style is best sir, I really understand all consept

  • @bharathdynamo9351
    @bharathdynamo9351 2 года назад +1

    Bro, i love your videos just because of you teaching method, thank you soo much🙂🙂.

  • @aakashtiwari3223
    @aakashtiwari3223 Год назад +3

    Beautiful explanation. Thank you very much

  • @aaravsstyle9852
    @aaravsstyle9852 Год назад +2

    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...

  • @sonumishra2217
    @sonumishra2217 3 года назад +3

    Apka pura java playlist dekha
    Thanks sir

  • @kunjankumarrawat9862
    @kunjankumarrawat9862 3 года назад +5

    I'm waiting for next video......

  • @asmrbuddy9498
    @asmrbuddy9498 2 года назад +3

    To the point information not like other youtuber those who always beat about the bash, hats off to teaching style :)
    👌

  • @Pooja-jc9wq
    @Pooja-jc9wq Год назад +1

    Bahut acche se samjaya sir ji aap ne 🙏

  • @amiiivaja1298
    @amiiivaja1298 Год назад +2

    Thank you so much sir for helping me in exams ...😊

  • @pandyapratham930
    @pandyapratham930 6 месяцев назад +1

    Nice explanation sir thank u so much 😊

  • @dipakdahal6573
    @dipakdahal6573 Год назад

    Your tutorials are really best

  • @heerarahman9989
    @heerarahman9989 2 года назад +1

    best lecture ever❣️

  • @shrinivas7068
    @shrinivas7068 Год назад

    Well explained, thak you!

  • @princejaat1853
    @princejaat1853 3 года назад +4

    Thanks guru g
    Bhagban aapko lambi umar de
    Aur aap hmesha khus rahe

  • @rishishori5563
    @rishishori5563 Год назад

    Good Explanation 👌

  • @rahulreddy3956
    @rahulreddy3956 2 года назад

    Thank you so much sir🙏🙏🙏

  • @shivamyadav-im7kb
    @shivamyadav-im7kb 3 года назад

    Thank U Sir-G 🙏🙏

  • @yogitakuldharan8946
    @yogitakuldharan8946 2 года назад +1

    Tqsm sir its really helpfull for me ..gbu

  • @yashok248
    @yashok248 Год назад

    Thank u for u r information.....

  • @jayaprakashsahoo8916
    @jayaprakashsahoo8916 3 года назад +4

    Javascript ke upar video banado sir.. Apka padhane ka way Acha laga.. I hope js ke upar koi video banaoge ap.

  • @naziyakalim8664
    @naziyakalim8664 2 года назад

    Very informative video sir, you have explained everything really well. Thanks a ton!

  • @poojasingh-tc1ns
    @poojasingh-tc1ns Год назад

    Best explaination👏

  • @shoaibsheikh1327
    @shoaibsheikh1327 Год назад

    Mindblowing explaination

  • @Artscene.
    @Artscene. 8 месяцев назад

    Aap bahut aage jaao sirr❤❤❤❤

  • @tamanarajput202
    @tamanarajput202 Год назад

    Thanks a lot sir 🎉❤🎉❤🎉❤🎉❤

  • @SanatanYogii
    @SanatanYogii 2 года назад

    Toward' One Million soon...…!

  • @modassir6269
    @modassir6269 3 года назад +4

    First view...❤️

  • @shabnamkhatun6296
    @shabnamkhatun6296 3 года назад

    Thank you sir.

  • @createbyme4526
    @createbyme4526 Год назад

    Thank you so much 🙏🙏

  • @mr.techie6
    @mr.techie6 2 года назад

    Thank you so much sir

  • @AshwaniKumar-ly4pl
    @AshwaniKumar-ly4pl 5 месяцев назад

    thanks sir nice explanation

  • @GeetaMasne
    @GeetaMasne Год назад

    Thank You Sir

  • @md.imtiaz4210
    @md.imtiaz4210 3 года назад +2

    Love you vai

  • @dikshagupta3276
    @dikshagupta3276 2 года назад

    Nice explanation

  • @nehathakur1355
    @nehathakur1355 Год назад

    Thx very much sir

  • @CodePressAcademy
    @CodePressAcademy 3 года назад

    Excellent

  • @nothing23412
    @nothing23412 Год назад

    thanks man!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @pratibhanevhare2757
    @pratibhanevhare2757 9 месяцев назад

    Your videos helpful to me please make a for how connect sqlplus to Oracle database

  • @pa2happiness13
    @pa2happiness13 3 года назад +2

    🙏👌🏼💞

  • @bhagirathjoshi4603
    @bhagirathjoshi4603 Год назад

    Saabaashh

  • @mudavathbalsingh5602
    @mudavathbalsingh5602 Год назад

    great work sir

  • @poonamkunwar9647
    @poonamkunwar9647 6 месяцев назад

  • @md.imtiaz4210
    @md.imtiaz4210 3 года назад +1

    Vaia bojlamna ato sondor kora bojan,tobuo like view hoi na kano...??

  • @maneeshakumari3864
    @maneeshakumari3864 2 года назад

    Thanks sir 🙏🙏🙏🙏

  • @malikakram7031
    @malikakram7031 Год назад

    Nice😊

  • @komallokhande2004
    @komallokhande2004 Год назад +1

    Sir please make video on Recovery Techniques for second year computer diploma students

  • @rebelstarstan6079
    @rebelstarstan6079 Год назад

    🙏

  • @settipallianilkumar5063
    @settipallianilkumar5063 2 года назад

    Super

  • @aryanverma642
    @aryanverma642 Год назад

    Nice bro

  • @In14daysbiky
    @In14daysbiky 2 года назад

    from Nepal

  • @babbaljotkaur3631
    @babbaljotkaur3631 3 года назад +2

    sir please ms office ki sari type kardo

  • @zameersiddiqui7359
    @zameersiddiqui7359 2 года назад

    Sir undo ke liye to apne rollback use kar lete hai but agar redo karna hoto to uske kaunsi query pass karenge?

  • @RavinderSingh-zx3ho
    @RavinderSingh-zx3ho Год назад +25

    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.

  • @Rohitkumar-yo8js
    @Rohitkumar-yo8js 2 года назад +1

    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?

  • @nareshns7738
    @nareshns7738 2 года назад

    Vk 😍👑

  • @sonumishra2217
    @sonumishra2217 3 года назад +1

    Sir data structure in java padha dijye❤️❤️

  • @something_diffrent6615
    @something_diffrent6615 Год назад

    Sr cursor package function trigger in oracle ....vo sab ke bhi video bnao na sr please

  • @YGZone.
    @YGZone. Год назад

    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

  • @Dipesh_karki
    @Dipesh_karki 3 года назад

    bro your video gone a help me in my STUDY i need this SQL command line tool link

  • @techsurferyp
    @techsurferyp 3 года назад +1

    Arey bhai Notes vi de diya karo yr plz ..

  • @skarsad2176
    @skarsad2176 Год назад

    Commit ,rollback and savepoint

  • @bilakkhan61
    @bilakkhan61 Год назад

    syntax of revoke and Grant in DCL plz

  • @abhishekranjan2617
    @abhishekranjan2617 2 года назад +1

    in my case rollback command not working. please help..!!

  • @siwanthe812
    @siwanthe812 Год назад

    Can you give me the pdf link of your notes sir? please

  • @gaytribhosle6299
    @gaytribhosle6299 2 года назад

    Sir please c#.net pr MCQ banaiye na

  • @Krishansaini01
    @Krishansaini01 9 месяцев назад

    Rollback delete ke bad kaise kam krne lg gya jbki vo bhi to commit data tha

  • @Allinone-si3tf
    @Allinone-si3tf Год назад

    *If we use commit; after save point c then rollback to c; possible*

    • @asharaju4169
      @asharaju4169 10 месяцев назад

      no....commit is a permanent change.rollback wont work for committed operations.

  • @samarborkar2309
    @samarborkar2309 5 месяцев назад

    sir where to get these handwritten notes

  • @surajkadam5429
    @surajkadam5429 Год назад

    can you please provide the notes

  • @utkalprasanga8516
    @utkalprasanga8516 4 месяца назад +1

    Sir is lefty🤨

  • @08mrunalgavali70
    @08mrunalgavali70 Год назад

    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

  • @VijayaLakshmi-xj8lv
    @VijayaLakshmi-xj8lv Год назад

    Bro how to bring the data we created after truncating the table?

    • @asharaju4169
      @asharaju4169 10 месяцев назад

      here you can do rollback

  • @rohitdesai183
    @rohitdesai183 Год назад

    commit karne ke baad mujhe permanent data delete karna hai toh konsa query use karna ka hai?

  • @sabayyalkhan9435
    @sabayyalkhan9435 Год назад

    Yr views.5000 hm or sub sirf 175 😳😳

  • @The_Dhruv_Bharadwaj
    @The_Dhruv_Bharadwaj Год назад

    Kya rollback table ko drop krne k baad bhi work krega ?

    • @asharaju4169
      @asharaju4169 10 месяцев назад

      no it wont work...drop is permanent.

    • @The_Dhruv_Bharadwaj
      @The_Dhruv_Bharadwaj 10 месяцев назад

      @@asharaju4169 exams over ho gye bhai kaash pehle bataya hota but anyways ... thanks 🥲

  • @SarahlouisKamara-cu3ez
    @SarahlouisKamara-cu3ez Год назад

    English

  • @mathmentornk664
    @mathmentornk664 2 года назад

    Sir ye DBMS hi hai kya

    • @ScareCrowFC
      @ScareCrowFC Год назад

      What do you think??

    • @mathmentornk664
      @mathmentornk664 Год назад

      @@ScareCrowFC sorry that mistakely happened my question is this is not there in my book that's why I was asked!

  • @IconicOdia
    @IconicOdia 6 месяцев назад

    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

    • @LearnCodingOfficial
      @LearnCodingOfficial  6 месяцев назад

      We also love and support our captain RohitMan sharma and King kohli Too❤️. Aur maine kisi ka insult nhi Kiya h

    • @masoomgamer1681
      @masoomgamer1681 2 месяца назад

      ​@@LearnCodingOfficialSir don't take serious , ye log wo hai free me khaana khaake bolte hai maja ni aya .

  • @khushalsinghchauhan4841
    @khushalsinghchauhan4841 7 месяцев назад

    Oye dhoni ki rank 1 kar

  • @lmit3704
    @lmit3704 3 года назад

    Sir DCL kaha geyaa

  • @diptkashyap5807
    @diptkashyap5807 Год назад

    Thanks sir