Get Absolute Values

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