Convert Data Types

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');

Convert VARCHAR String To INTEGER

-- Select the BANK_BALANCE column converted into an integer
SELECT CAST(BANK_BALANCE AS INTEGER)
-- From the SUPERHEROES table
FROM SUPERHEROES;
BANK_BALANCE::INTEGER
-100
233
200

Convert VARCHAR String To INTEGER (Alternative)

-- Select the BANK_BALANCE column converted into an integer
SELECT BANK_BALANCE::INTEGER
-- From the SUPERHEROES table
FROM SUPERHEROES;
BANK_BALANCE::INTEGER
-100
233
200