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');
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
没有评论:
发表评论