Create Temporary Table
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)
);
Add Rows, One 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
-- View the table
SELECT ALTER_EGO, BANK_BALANCE FROM SUPERHEROES;
ALTER_EGO |
BANK_BALANCE |
Diamond Ninja |
-100.20 |
The Dragoon |
200.30 |
View Table With Absolute Values Of Bank Balance
-- View the table with absolute bank values
SELECT ALTER_EGO, ABS(BANK_BALANCE) FROM SUPERHEROES;
ALTER_EGO |
ABS(BANK_BALANCE) |
Diamond Ninja |
100.20 |
The Dragoon |
200.30 |