Learning machine learning? Try my machine learning flashcards or Machine Learning with Python Cookbook.
Create Table From Query
Create Table Of Superheroes
-- Create a table called SUPERHEROES. If it already exists, replace it.
CREATE OR REPLACE 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)
);
Insert Rows For Each Superhero
-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES
-- With the values
VALUES
('XF6K4', 'Chris Maki', 'Diamond Ninja', '-100.20'),
('KD5SK', 'Donny Mav', 'The Dragoon', '200.30');
View Table Of Superheroes
-- View the table
SELECT * FROM SUPERHEROES;
ID | NAME | ALTER_EGO | BANK_BALANCE |
---|---|---|---|
XF6K4 | Chris Maki | The Bomber | -100.20 |
KD5SK | Donny Mav | Nuke Miner | 200.30 |
Create A New Table From A Query
-- Create a table called HEROES based on...
CREATE OR REPLACE TABLE HEROES AS
-- A query
SELECT * FROM SUPERHEROES;
View New Table
Note: Because our query, SELECT * FROM SUPERHEROES
selected all data from the SUPERHEROES
table, our new table, HEROES
will look the same as SUPERHEROES
.
-- View the table
SELECT * FROM HEROES;
ID | NAME | ALTER_EGO | BANK_BALANCE |
---|---|---|---|
XF6K4 | Chris Maki | The Bomber | -100.20 |
KD5SK | Donny Mav | Nuke Miner | 200.30 |