Hi Gurus
I am working on Oracle 12.2.0.1.0.
I have created a table and trying to insert data into table. But was not able to load it. Can you please help me to insert data without any issues.
CREATE TABLE USER_TYPE
( ID_TYPE VARCHAR2(13 BYTE) NOT NULL ,
DESCRIPTION VARCHAR2(255 BYTE),
REC_STS_CODE CHAR(1 BYTE) NOT NULL ,
INSERT_USER VARCHAR2(20 BYTE) NOT NULL ,
INSERT_PROCESS VARCHAR2(80 BYTE) NOT NULL ,
INSERT_TIMESTAMP TIMESTAMP (6) NOT NULL ,
UPDATE_USER VARCHAR2(20 BYTE),
UPDATE_PROCESS VARCHAR2(80 BYTE),
UPDATE_TIMESTAMP TIMESTAMP (6),
UPS_SRC_NUMBER NUMBER,
O_INSERT_TIMESTAMP TIMESTAMP (6),
O_UPDATE_TIMESTAMP TIMESTAMP (6)
);
INSERT INTO USER_TYPE VALUES('100','ORACLE PRODUCT','A','K12345','MANUAL',sysdate,'<null>','<null>','<null>','','','');
ORA-01858: a non-numeric character was found where a numeric was expected
if I put to_char(sysdate) instead of SYSDATE then also getting the error ORA-01843: not a valid month.
Can you please help me to correct the syntax and load the data.
Thanks
Amy.