How can i make my integer to be exactly in the number of digits that i gave in Oracle?

Question

I want to accept only the number that is given in the number of digits that I chose. How can i do that in Oracle?

Answer 1

CREATE TABLE suppliers
(
  supplier_id numeric(4),
  supplier_name varchar2(50),
  CONSTRAINT check_supplier_id
  ***CHECK (supplier_id BETWEEN 100 and 9999)***
);