-
when I run the following it complains about INTERVAL YEAR TO MONTH datatype ???
CREATE TABLE product_information
( product_id NUMBER(6)
, product_name VARCHAR2(50)
, product_description VARCHAR2(2000)
, category NUMBER(2)
, weight_class NUMBER(1)
, warranty_period INTERVAL YEAR TO MONTH
, supplier_id NUMBER(6)
, product_status VARCHAR2(20)
, list_price NUMBER(8,2)
, min_price NUMBER(8,2)
, catalog_url VARCHAR2(50)
, CONSTRAINT product_status_lov
CHECK (product_status in ('orderable','planned','under development','obsolete')
)
) ;
-
??
What is interval year to month datatype?
-
interval year to month datatype is a user defined data type and is not native to oracle hence the error.first you have to create the type using create type command
