Oracle: sequence create / drop / reindex

 SELECT sequence_name,
       last_number,
       increment_by,
       ( last_number ) AS next_value
FROM   user_sequences
WHERE  sequence_name = 'PP_PROTOTYPE_SEQ';

-- Drop sequence pp_prototype_seq if it exists
BEGIN EXECUTE IMMEDIATE 'DROP SEQUENCE pp_prototype_seq';

EXCEPTION WHEN OTHERS THEN IF SQLCODE != -2289 THEN -- ORA-02289: sequence does not exist
RAISE;
END IF;
END;
/

-- Create a sequence for the auto-increment ID
CREATE SEQUENCE pp_prototype_seq 
    START WITH 24 
    INCREMENT BY 1 
    NOMAXVALUE 
    NOCACHE;