-
when I try to create tables with columns of datatype TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE I get unrecognized datatype errors.
CREATE TABLE orders
( order_id NUMBER(12)
, order_date TIMESTAMP WITH LOCAL TIME ZONE NOT NULL
, order_mode VARCHAR2(8)
, customer_id NUMBER(6) NOT NULL
, order_status NUMBER(2)
, order_total NUMBER(8,2)
, sales_rep_id NUMBER(6)
, CONSTRAINT order_mode_lov
CHECK (order_mode in ('direct','online'))
, constraint order_total_min
check (order_total >= 0)
) ;
-
Because TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE are not datatypes in Oracle.
Check Oracle SQL Reference for valid datatypes:
http://technet.oracle.com/docs/produ...a85397/toc.htm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|