Hi Manu,.tq for sharing useful video,. Pls help me. How do i do If i want to pull data from existing tables through temp table inside procedure in Oracle.???
Sure checkout the below playlists, hope you have subscribed to our channel :) th-cam.com/video/NYwZPgnOIk4/w-d-xo.html and another one th-cam.com/video/OgEmJtOQ7hg/w-d-xo.html
Hello Sir , Thanks for the explanation , I have a question If we associate a trigger in a GTT ( Transaction specific ) to replicate the same inserted data in another permanent table ! ON COMMIT the rows will be deleted in the GTT ! but what will happen to the data replicated into another table by that Trigger ? Also can we have check / not null / unique key constraints in a GTT ?
Hi ,the video is very nice.But I have two questions on this . 1. On delete preserve :usually as it is a temporary table data will be present till session is active ,then why to use this statement. 2. Not logged on rollback :when generally we do rollback ,data goes off ,then why use this. Please clear my doubt.
When you do not want to store the data permanently into the table, use ON COMMIT DELETE. Say, you need to insert data into a table by selecting data from multiple tables and performing some complex transformations on them. So in such cases GTT will let you store any intermediate form of data, now you do not want the data in GTT after the insert is completed, in such cases an ON COMMIT DELETE will flush out the data from GTT after an INSERT is followed by a COMMIT. Also this will help you to bother less about the data in GTT and focus on actual functionality.
Can you insert a SQL statement into a temporary table? For example: INSERT INTO GTT_COUNTRY (select country_ID, country_name from country_table where rownum
ya Isaiah we can :) -- create gtt table create global temporary table test_gtt ( id number, name varchar2(50) ); -- create table create table test_insert (id number, name varchar2(50) ); -- insert record into table insert into test_insert values (100,'kishan'); -- commit commit; -- insert data into gtt with a insert into select insert into test_gtt select * from test_insert; -- query gtt table select * from test_gtt; -- 100 kishan Hope this helps!!! Subscribe and like, if you haven't done it yet :)
Your explanation is so fantastic. Thank You so much for your best explanation....
I got good clarity by seeing your vedio thanks a lot
Please upload some senirio based questions also
Thak you for clear explanation
Well Explained.
Can you Pls apply this GTT to a Performance issue and make a video ,So that everyone will be aware of Real usage of GTT ?
Hi Manu,.tq for sharing useful video,. Pls help me. How do i do If i want to pull data from existing tables through temp table inside procedure in Oracle.???
You have explained really Awesome!!! can you please explain about not logged [on rollback delete rows] also?
Thank You! I,couldn't hear your voice much louder.
Do you have any other videos' to watch out about SQL?
Sure checkout the below playlists, hope you have subscribed to our channel :)
th-cam.com/video/NYwZPgnOIk4/w-d-xo.html
and another one
th-cam.com/video/OgEmJtOQ7hg/w-d-xo.html
Hello Sir , Thanks for the explanation , I have a question
If we associate a trigger in a GTT ( Transaction specific ) to replicate the same inserted data in another permanent table !
ON COMMIT the rows will be deleted in the GTT ! but what will happen to the data replicated into another table by that Trigger ?
Also can we have check / not null / unique key constraints in a GTT ?
very nice. Thanks a lot for helping me understanding about GTT
Welcome Syed!!! Hope you have given the video a "thumbs up" and subscribed to our channel :)
Very nice and simple explanation kishan...
Thanks!!! I am glad you enjoyed it, hope you have give the video a "thumbs up" and have subscribed to our channel
Nice Explanation Good work!! Thank you
Simple and best explanation :)
Hi ,the video is very nice.But I have two questions on this .
1. On delete preserve :usually as it is a temporary table data will be present till session is active ,then why to use this statement.
2. Not logged on rollback :when generally we do rollback ,data goes off ,then why use this.
Please clear my doubt.
Audio is not loud. Quiet louder is expected.
Sir have one doubt, in which case we use " On commit Delete" command...if possible then please explain,thank you Sir
When you do not want to store the data permanently into the table, use ON COMMIT DELETE.
Say, you need to insert data into a table by selecting data from multiple tables and performing some complex transformations on them. So in such cases GTT will let you store any intermediate form of data, now you do not want the data in GTT after the insert is completed, in such cases an ON COMMIT DELETE will flush out the data from GTT after an INSERT is followed by a COMMIT.
Also this will help you to bother less about the data in GTT and focus on actual functionality.
can we create GTT using dynamic SQL? If yes please explain.
Yes we can create
Can you insert a SQL statement into a temporary table?
For example:
INSERT INTO GTT_COUNTRY (select country_ID, country_name from country_table where rownum
ya Isaiah we can :)
-- create gtt table
create global temporary table test_gtt
(
id number,
name varchar2(50)
);
-- create table
create table test_insert
(id number,
name varchar2(50)
);
-- insert record into table
insert into test_insert
values (100,'kishan');
-- commit
commit;
-- insert data into gtt with a insert into select
insert into test_gtt
select * from test_insert;
-- query gtt table
select * from test_gtt;
-- 100 kishan
Hope this helps!!!
Subscribe and like, if you haven't done it yet :)
It is necessary to mention on commit delete and preserve while creating gtt
Great explanation of global temp tables. Can you speak up a little bit? Your volume was low on this video
Good Explanatin..
Thanks, man!!! :) Hope you have liked the video and subscribed to our channel for latest updates.
a very helpful vedio
Thanks, hope you have given the video a thumbs up and subscribed to our channel for all the latest updates!!!
Bro can u upload video on Oracle architecture
Nice
Explanation is good but could have spoken a bit louder.
Buddy, Video is good but while you speak that time breathing sound is coming and it is disturbing so remove this sound.
Nice bro please speak loud
Sure man!!! :) have taken care of it from my recent uploads.