I'm working on a Database assigment but I'm kind of stuck. It seems to be the Double value that's causing the issue because when I use the Varchar data type I can create my table. Is there any way I can use Double without using Varchar.
Any help is much appreciated :)
CREATE TABLE MOVIE_INFO ( MOVIE_ID INT not null primary key GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), MOVIE_TITLE VARCHAR(30) NOT NULL,. ACTORS VARCHAR(40) NOT NULL, CATAGORY VARCHAR(25) NOT NULL, RELEASE_YEAR INT NOT NULL, LANGUAGE_ VARCHAR (30) NOT NULL, LENGTH_ VARCHAR (15) NOT NULL, SPECIAL_FEATURES VARCHAR (6) NOT NULL, AGE_RATING VARCHAR (8) NOT NULL, MOVIE_RATING INT NOT NULL, FORMAT_ VARCHAR (10) NOT NULL DVD_RENTAL_COST DOUBLE , BLURAY_RENTAL_COST DOUBLE, DVD_REPLACEMENT_COST DOUBLE, BLURAY_REPALCEMENT_COST DOUBLE, STOCK VARCHAR (20) NOT NULL );