CREATE TABLE TNAME( COL1 TYPE1, COL2 TYPE2, COL3 TYPE3); INSERT INTO TNAME(COL1,COL2,COL3) VALUES(VALUE1,VALUE2,VALUE3);INSERT INTO TNAME(COL1,COL2,COL3) SELECT COL1_,COL2_,COL3_ FROM OTHER_TABLE WHERE ...;
ORA-01741 illegal zero-length identifier Cause: An attempt was made to use two double quotes ("") as an identifier. An identifier must be at least one character long.Action: Insert at least one character between the double quotes in the identifier.If a blank identifier is required, specify a blank space between the doublequotes (" ").还是插入语句写得有一定的问题。
ORA-01741:illegal zero-length identifier
COL1 TYPE1,
COL2 TYPE2,
COL3 TYPE3);
INSERT INTO TNAME(COL1,COL2,COL3) VALUES(VALUE1,VALUE2,VALUE3);INSERT INTO TNAME(COL1,COL2,COL3)
SELECT COL1_,COL2_,COL3_
FROM OTHER_TABLE
WHERE ...;
Cause: An attempt was made to use two double quotes ("") as an identifier. An identifier must be at least one character long.Action: Insert at least one character between the double quotes in the identifier.If a blank identifier is required, specify a blank space between the doublequotes (" ").还是插入语句写得有一定的问题。