Insert problems

Hi,

I want to do the following:

INSERT INTO TABLE1(FIELD1, FIELD2) VALUES(SEQ.NEXTVAL, (SELECT FIELD2 FROM TABLE1 WHERE ID = 1)); The reason for this statement is that the value with id 1 is an default value and I want a copy of this. But it doesn't work I become ORA-00936: missing expression error and I don't no why.
regards Dirk Received on Tue Nov 16 1999 - 07:58:42 CST