CREATE SEQUENCE supplier_seq
  MINVALUE 1
  MAXVALUE 999
  START WITH 1
  INCREMENT BY 1
  CACHE 1;

SELECT LPAD(supplier_seq.nextval,3,0) FROM DUAL; -- 001, 002, 003