1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
SQL> INSERT INTO PGR_TEST_TMP (CODHOP,MATRIC,DATEFF,NUMORD,GRGRAD,GRSTAT,GRCANN,GRCMOT,GRGRFF,GRDPRI,GRDANC,GRDEMP,GRDDEC,GRFCIR,DATFIN,GRGRG2,GRMESU,GRPCOM) values ('088','000008',TO_DATE(01/11/1994),0,'1312',' ','1',' ',' ',TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),' ',TO_DATE(31/05/1999),'1312',TO_NUMBER(00000001),'N');
INSERT INTO PGR_TEST_TMP (CODHOP,MATRIC,DATEFF,NUMORD,GRGRAD,GRSTAT,GRCANN,GRCMOT,GRGRFF,GRDPRI,GRDANC,GRDEMP,GRDDEC,GRFCIR,DATFIN,GRGRG2,GRMESU,GRPCOM) values ('088','000008',TO_DATE(01/11/1994),0,'1312',' ','1',' ',' ',TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),TO_DATE(01/05/1998),' ',TO_DATE(31/05/1999),'1312',TO_NUMBER(00000001),'N')
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
SQL> desc PGR_TEST_TMP
Name Null? Type
----------------------------------------- -------- ----------------------------
CODHOP NOT NULL CHAR(3)
MATRIC NOT NULL CHAR(6)
DATEFF NOT NULL DATE
NUMORD NOT NULL NUMBER(1)
GRGRAD NOT NULL CHAR(4)
GRSTAT NOT NULL CHAR(2)
GRCANN NOT NULL CHAR(1)
GRCMOT NOT NULL CHAR(1)
GRGRFF NOT NULL CHAR(4)
GRDPRI NOT NULL DATE
GRDANC NOT NULL DATE
GRDEMP NOT NULL DATE
GRDDEC NOT NULL DATE
GRFCIR NOT NULL CHAR(2)
DATFIN NOT NULL DATE
GRGRG2 NOT NULL CHAR(4)
GRMESU NOT NULL NUMBER(8)
GRPCOM NOT NULL CHAR(1) |
