toget values from object table

[Prabhudatta Choudhury]

Hi,

I have a table where an object is a field. that object contains another 4 columns. How can I retrieve data from that object table.
ALTER TABLE MainDBA.NT_LP_CB_NEWTEST_ABW DROP PRIMARY KEY CASCADE; DROP TABLE MainDBA.NT_LP_CB_NEWTEST_ABW CASCADE CONSTRAINTS; CREATE TABLE MainDBA.NT_LP_CB_NEWTEST_ABW ( USER_ID NUMBER(10), KEY NUMBER(9), Function CODE VARCHAR2(14 BYTE), CREATED_DATE DATE, MODIFIED_DATE DATE, OB_LP_COREBL_MAINT_INFO MainDBA.OB_LP_COREBAL_MAINT_INFO_NT ) NESTED TABLE OB_LP_COREBL_MAINT_INFO STORE AS TAB_LP_CB_NEWTEST_ABW TABLESPACE Main_TP_GEN_DATA

I need one java code where I can fetch data from the inner object data from this table.
I tried with select statement but remained unsuccesfull. Please let me know what to do.

[John Jai]

inner object data from this table

which column you are trying to get data from?

I tried with select statement but remained unsuccesfull

Its not much helping. Please post some code you tried.. ItDoesntWorkIsUseless

[Campbell Ritchie]

I think this question would sit better on our databases forum. Moving.