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

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -