sql - Inserting an array within an object construction, constructed based on a query -
How do I use one object if I need to insert values into the original object?
Obviously I am using the wrong syntax.
Edit, getting closer:
Insert in myTable mybigtype ('foo', 'bar', 'fizzle', myraiflatataepages (refraction from another table) (S) where Esteemen = 'dingle' or estmenam = 'fengel'))); was created in the form of mylittletype:
create myRR myRight of 20R (20) as myarrayoflittletypes < P> AnotherTable was created as: Create another table of mylittletype Mybigtype has some strings and a type that references mylittletype objects Has been defined to keep an array of. So I want to be able to insert a line in this table which creates an object of type mybigtype with the array created on the basis of my definition. Can I do all this in an assembly? Or have I put it in a blank placeholder and later need to update this area?
The Oracle's current complaint is
ORA-01427: Single-row subquery returns more than one line How can I get multiple OID returns in this array in an object?
You almost got it!
Enter myTable in mybigtype ('foo', 'bar', 'fizzle', myarrayoflittletypes ((select referee (sm.littatype) in another table s where sms .Litettype .stname = 'dingle or simi littapepe.staman =' fagle ')));
Comments
Post a Comment