Retrieve data from the nested table?
397000Jun 18 2003 — edited Jun 18 2003Greetings..
Hi!! Gurus..
I have following definitions in DB.. And then I have no clues to retrieve data from the Nested Table.
How can I get the data from the nested tables..
CREATE TABLE TEST_TBL (
ORDER_NUMBER Number(10) NOT NULL,
TEST_CHANNEL CHANNEL_TYPE )
NESTED TABLE TEST_CHANNEL STORE AS CHANNEL_TYPE;
CREATE OR REPLACE TYPE CHANNEL AS OBJECT (
Test_TYPE VARCHAR2(20),
Test1 Number,
Test2 Number,
Test3 Number,
)
I tried to retrieve a result using the following method without nothing..
Select * From TEST_TBL
int ORDER_NUMBER = 0;
while (rs.next()) {
ORDER_NUMBER = rs.getInt(1);
java.sql.Struct channelType = (java.sql.Struct)rs.getObject(2);
}