GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES

Рет қаралды 24,607

Kishan Mashru

Күн бұрын

Пікірлер: 35

@dibyapdp 3 жыл бұрын

Your explanation is so fantastic. Thank You so much for your best explanation....

@govindugovindu617 5 жыл бұрын

I got good clarity by seeing your vedio thanks a lot Please upload some senirio based questions also

@sriramanbazhagan4394 Жыл бұрын

Thak you for clear explanation

@rakeshv2020 7 жыл бұрын

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 ?

@BewithuNnk 2 жыл бұрын

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

@ramchinthakayala2092 5 жыл бұрын

You have explained really Awesome!!! can you please explain about not logged [on rollback delete rows] also?

@sanjaykallakuri7010 7 жыл бұрын

Thank You! I,couldn't hear your voice much louder. Do you have any other videos' to watch out about SQL?

@KishanMashru 7 жыл бұрын

Sure checkout the below playlists, hope you have subscribed to our channel :) kzbin.info/www/bejne/hIrai4Odo7R8oZY and another one kzbin.info/www/bejne/hZionn2qhLZqnsk

@gauravdutta5486 4 жыл бұрын

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 ?

@nimnim1866 7 жыл бұрын

very nice. Thanks a lot for helping me understanding about GTT

@KishanMashru 7 жыл бұрын

Welcome Syed!!! Hope you have given the video a "thumbs up" and subscribed to our channel :)

@anjaneyulug4979 7 жыл бұрын

Very nice and simple explanation kishan...

@KishanMashru 7 жыл бұрын

Thanks!!! I am glad you enjoyed it, hope you have give the video a "thumbs up" and have subscribed to our channel

@nageswararaoboya4670 6 жыл бұрын

Nice Explanation Good work!! Thank you

@anilk3417 5 жыл бұрын

Simple and best explanation :)

@sprangyabehera4227 5 жыл бұрын

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.

@morsheddld 5 жыл бұрын

Audio is not loud. Quiet louder is expected.

@cpunsb4150 6 жыл бұрын

Sir have one doubt, in which case we use " On commit Delete" command...if possible then please explain,thank you Sir

@KishanMashru 6 жыл бұрын

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.

@ramchinthakayala2092 4 жыл бұрын

can we create GTT using dynamic SQL? If yes please explain.

@sreenivasborra9540 2 жыл бұрын

Yes we can create

@KupoIsaiah 7 жыл бұрын

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

@KishanMashru 7 жыл бұрын

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 :)