2021年3月4日星期四

Why am I getting error message: ORA-01861: literal does not match format string when copied from textbook

I am using oracle 18c and trying to insert info into a row, but keep getting the error message: ORA-01861: literal does not match format string and am using this script:

CREATE TABLE acctmanager  (amid CHAR(4),   amfirst VARCHAR2(12)  NOT NULL,   amlast VARCHAR2(12)  NOT NULL,   amedate DATE DEFAULT SYSDATE,   amsal NUMBER(8,2),   amcomm NUMBER(7,2) DEFAULT 0,   region CHAR(2),    CONSTRAINT acctmanager_amid_pk PRIMARY KEY (amid),    CONSTRAINT acctmanager_region_ck       CHECK (region IN ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')));  

And I am trying to insert: INSERT INTO acctmanager VALUES ('T500', 'NICK', 'TAYLOR', '05-SEPT-09', 42000, 3500, 'NE');

enter image description here

https://stackoverflow.com/questions/66486185/why-am-i-getting-error-message-ora-01861-literal-does-not-match-format-string March 05, 2021 at 11:06AM

没有评论:

发表评论