What am i doing wrong?

[Welshy]

So ive created a table catalogue with the following command:

CREATE TABLE CATALOGUE
		(CATALOGUENUMBER VARCHAR2(6) NOT NULL,
		 TITLE VARCHAR2(30) NOT NULL,
		 GENRE VARCHAR2(20) NOT NULL,
		 SUPPLIER VARCHAR2(20) NOT NULL,
		 RELEASEDATE DATE,
		 CERTIFICATE VARCHAR2(3) NOT NULL,
		 RENTALCOST NUMBER(2,2) NOT NULL,
		 PRIMARY KEY (CATALOGUENUMBER));

and inserting a row with the following command:

INSERT INTO CATALOGUE VALUES ('C01001','X-Men 3: The Last Stand','Action','20th Century Fox',TO_DATE('02-OCT-2006', 'DD-MON-YYYY'),'12',4);

I've tried loads of different films, genres etc, but they all seem to result in the error message "ORA-01438: value larger than specified precision allowed for this column".

Now i really have no clue why it wont add the rows because as far as i can see the values im entering are within valid ranges.

Could anyone please enlighten me as ive only been doing SQL for a few weeks

 

[Welshy]

ah i didnt know the first number was to include any decimal places! I'd kiss you both if you were here

thanks guys!