Learning machine learning? Try my machine learning flashcards or Machine Learning with Python Cookbook.

Create Temporary Table

28 Jan 2019

Create Temporary Table

The temporary table will last until the session ends.

-- Create a table called SUPERHEROES.
CREATE OR REPLACE TEMP TABLE SUPERHEROES (
  -- Column called ID allowing up to five characters
  "ID" VARCHAR (5), 
  -- Column called NAME allowing up to 100 characters
  "NAME" VARCHAR(100),
  -- Column called ALTER_EGO allowing up to 100 characters
  "ALTER_EGO" VARCHAR(100),
  -- Column called BANK_BALANCE allowing 38 digits with 2 after the decimal point
  "BANK_BALANCE" NUMBER(38, 2)
);