Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is Temp Table and type of temp table?

Question Posted / shwetha n k

Answer Posted / shwetha n k

GLOBAL TEMPORARY TABLES in Oracle are tables that are created distinct within the Oracle sessions.
Oracle support two types of temporary tables.
•Global Temporary Tables : Available since Oracle 8i and subject of this article.
•Private Temporary Tables : Available since Oracle 18c. Discussed here.
you can create GTT table with on commit delete rows or on commit preserved rows.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the requirement of self-join?

1025

What is not in sql?

899

How to get unique records from a table?

896

What is mdf ldf and ndf?

931

Does mysql support pl sql?

1098

What is sqlite used for?

933

How do you explain an index?

1222

What is schema in sql example?

1088

Why are aggregate functions called so?

896

Why do we use joins?

984

What is the use of nvl function?

1124

What is the importance of sqlcode and sqlerrm?

1277

What is java sql connection?

964

How to set up sql*plus output format in oracle?

974

what is recursive stored procedure? : Sql dba

930