begin
FOR c_d
IN (SELECT *
FROM table_a
)
LOOP
c_d.id := NULL;
INSERT INTO table_a values (c_d);
END LOOP;
end;
this gives an ORA-00947: not enough values
in the line of "INSERT INTO table_a values (c_d);"
How to fix it?
.
.
.
.
.
.
.
.
.
.
Take the parenthesis out!
INSERT INTO table_a values c_d;
No comments:
Post a Comment
Os comentários são moderados.
The comments are moderated.