Learning machine learning? Try my machine learning flashcards or Machine Learning with Python Cookbook.
Create Temporary Table
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)
);