Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

Oracle Global Temporary Table

Profile picture for user akshita.goel
Written by akshita.goel on 10/20/2021 - 13:29

In other programming languages like Python and c++, you all might have studied the concept of Local and Global Variables. 

  1. Local Variable: are those that are accessed only within the block of code it is declared.
  2. Global Variable: are those to be called from anywhere throughout the code.

Similarly, we have the concept of Global Temporary Variable and Local Temporary Variable in SQL. Global Temporary Tables, once created, are accessed from any connection in that database. 

NOTE The Global Temporary Table automatically deletes if the connection into which it creates is closed.

Syntax

Create Global temporary Table Table_name
(
    Column1 Datatype(size),
    Column2 Datatype(size),....
);

Global temporary Table is the keyword to create a Global temporary Table. Table_name is the name of the table that you want to create.

Global Temporary Table in Oracle Example

We want to create a Global Temporary Table named Subjects wherein we want to store the different names of Subjects. Follow the code below to do the same:

create global temporary table subjects
(
Name Varchar(20)
);

Output

global temporary table oracle example

The above output shows that the Global Temporary Table named Subjects is created

Related Content
Oracle Tutorial
Oracle: Cross Join
Oracle Drop Column
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use