How do I insert data into a object relational table with multiple ref in the schema.
Posted
by Yiling
on Stack Overflow
See other posts from Stack Overflow
or by Yiling
Published on 2010-05-03T17:24:24Z
Indexed on
2010/05/03
17:28 UTC
Read the original article
Hit count: 194
I have a table with a schema of Table(number, ref, ref, varchar2, varchar2,...).
How would I insert a row of data into this table?
When I do:
"insert into table values (1, select ref(p), ref(d), '239 F.3d 1343', '35 USC § 283', ... from plaintiff p, defendant d where p.name='name1' and d.name='name2');"
I get a "missing expression" error.
If I do:
"insert into table 1, select ref(p), ref(d), ... from plaintiff p, defendant where p.name=...;"
I get a "missing keyword VALUES" error.
© Stack Overflow or respective owner