Create Table Of Superheroes
-- Create a table called SUPERHEROES.
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),
-- Column called AGE allowing 3 digits with 0 after the decimal point
"AGE" NUMBER(3, 0)
);
Insert Rows For Each Superhero
-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES
-- With the values
VALUES
('XF6K4', 'Chris Maki', 'The Bomber', '-100.20', '14'),
('KDEJ4', 'Rich Richardson', 'Mr. Money', '233.20', '12'),
('KD5SK', 'Donny Mav', 'Nuke Miner', '200.30', '59');
Create An Alias For Column
-- Select...
SELECT
-- the NAME column from the table, call it REAL_NAME
NAME AS REAL_NAME,
-- the AGE column
AGE
-- From the SUPERHEROES table
FROM SUPERHEROES
REAL_NAME |
AGE |
Chris Maki |
14 |
Rich Richardson |
12 |
Donny Mav |
59 |
Create An Alias For Column (Alternative)
-- Select...
SELECT
-- the NAME column from the table, call it REAL_NAME
NAME REAL_NAME,
-- the AGE column
AGE
-- From the SUPERHEROES table
FROM SUPERHEROES
REAL_NAME |
AGE |
Chris Maki |
14 |
Rich Richardson |
12 |
Donny Mav |
59 |