Global Temporary Table (GTT) Actual Concept | Where we can use GTT
Vložit
- čas přidán 11. 03. 2020
- #globaltemporarytable #Temptable
#table #sql #oracleshooter #OracleShooter
Cover Topic:- This video explains the real concept of " global temporary tables in SQL" with examples.
it very helpful to all the students and beginners as well. so keep going with oracle shooter.
global temporary tables in Oracle are permanent database objects that store data on disk and visible to all sessions. However, the data stored in the global temporary table is private to the session.
Full Blogs Link:-
oracleshooter.blogspot.com/20...
My Vlog Channel link:-
/ mylifemyface
Some Entertainment Video links:-
• Video
• Mylife Myface Vlog #22...
• Video
Contact Info :-
Instagram:- / mylifemyface
Facebook :- / mylifemyface11
Twitter :- / mylifemyface11
Blogger :- oracleshooter.blogspot.com
Email Id :- oracle.shooter@gmail.com
Telegram Link:- t.me/joinchat/LKP54BKdxH8-Gza...
whatsapp Group :- chat.whatsapp.com/ISOb4Zs84FR...
WHATTT......A GREAT EXPLANATION ....THANKS SIR.
Thank you
Really really amazing..
Appreciate you hard work , hard work, sincerity and knowledge.
After watching video, gtt is super clear now..
Thanks a lot
Thank you Sir Doubts Cleared!
Very well explanation sir
Nice explanation sir... Very helpful
Great video Sir ❤
Thank you Bro ... Please keep it up
Great video.
Thank you Sir.. ❤️
Great video !! Easy to understand !!
Thanks Monika
Nice video
Thanks utsav
oracle india interview question ..what is GTT ?why it is used .give me one example.
thanks sir for the video.
great thank you
Thank you
explain with some scenario ..why we need to use it...
Hi Sir, Nice explanation about GTT.
Can we create index,trigger and views on GTT.
I gone through one of the oracle document which says ON COMMIT PRESERVE ROWS clause indicates that rows should persist beyond the end of the transaction. They will only be removed at the end of the session. But as you shown in video after committing the transaction rows are deleted. how to understand this.
thanks a lot
Nice video sir. I have 1 doubt, when to use preserve rows and when to use delete rows with ON COMMIT clause. What is the difference between the two based on usage?
only one thing you missing here that if we do not specify the type of GTT (on commit preserve/delete rows) the by default it becomes on commit delete rows.
Yes praveen you are right. Thanks
Sir,
Please provide batch script to load Json file in to oracle table un db
How do we transfer data from Global Temporary Table to another table?
Are you able to transfer?
Did you try to transfer?
Can we get data from GTT table?
Most of the time No, during the session it depends upon the commit
@@OracleShooter If I want to get data from pos_po_vendors_gt table? Is there any way to get it?
@@OracleShooter how can I transfer data to another table?