Filling property-collection

Filling property-collection

Postby k7e » Mon 24 Dec 2012 10:03

We have got an object. The object has some properties. One of properties is collection. How we can populate both properties and property-collection in 1 query.

CREATE OR REPLACE TYPE pack.D_O IS OBJECT(
r number,
l number,
s_pack number(3),
s_pack_name varchar2(50),
n_uch number(5),
type_name varchar2(30),
date_att date,
cause_att number(2),
cause_att_name varchar2(250)
)

----------------------------------------------------------------------
CREATE OR REPLACE TYPE pack.D_T IS TABLE OF pack.D_O;

----------------------------------------------------------------------
CREATE OR REPLACE TYPE pack.d2_o IS OBJECT(
d NUMBER(5),
n VARCHAR2(75),
m VARCHAR2(75),
f number,
z pack.D_T
)

----------------------------------------------------------------------
select pack.d2_O(manager,
name,
office,
regalias,
? -- how to fill "z" collection here, using subquery or something similar?
)
from
t1,t2
where
.....
.....
k7e
 
Posts: 3
Joined: Mon 10 Dec 2012 05:38

Re: Filling property-collection

Postby Shalex » Wed 26 Dec 2012 16:40

This question exceeds the goals of our support because it is not provider-specific.
We recommend you to post it at https://forums.oracle.com or http://stackoverflow.com/.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle