data type for positive number
562167Dec 11 2007 — edited Dec 11 2007Hi,
i have created a table like this:
CREATE TABLE pos_tab (id NUMBER PRIMARY KEY, name VARCHAR2(50), quantity NUMER);
i want the quantity column should not accept negative value.if i give negative values, it ll throw an error.
I do not know which datatype is used for doing this.
plz help me