AnsweredAssumed Answered

Copy data in ODF_MULTI_VALUED_LOOKUPS

Question asked by navzjoshi00 Champion on Feb 15, 2013
Latest reply on Nov 22, 2017 by Dave_3.0
I have an attribute, attribute1 in the ODF_MULTI_VALUED_LOOKUPS table. I've created another attribute, attribute2, and want to copy data of attribute1 in attribute2.

I wrote an insert statement, but it throws error -

insert into ODF_MULTI_VALUED_LOOKUPS values (select object,pk_id,'attribute2',seq,value,created_date,created_by,last_updated_date,last_updated_by from ODF_MULTI_VALUED_LOOKUPS where attribute='attribute1');

Error starting at line 1 in command:
insert into ODF_MULTI_VALUED_LOOKUPS values (select object,pk_id,'attribute2',seq,value,created_date,created_by,last_updated_date,last_updated_by from ODF_MULTI_VALUED_LOOKUPS where attribute='attribute1')
Error at Command Line:1
Error report:
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:

Any input ?

NJ

Outcomes