I have the following insert query - that does not work. Is there a solution to my problem.
NOTES: VCIL_KEY is a constant
VCIL_OP_KEY needs to be the next value from an oracle sequence.
insert into vcil_summary (vcil_key,
(select distinct part_no,
where part_no = 'PART8001'
and cil_location = 'V'));
Thanks for the help.