A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
toget values from object table
Joined: Jul 03, 2009
Sep 17, 2011 04:53:59
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
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.
Joined: May 31, 2011
Sep 17, 2011 05:32:23
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..
Joined: Oct 13, 2005
Sep 17, 2011 08:58:23
I think this question would sit better on our databases forum. Moving.
It is sorta covered in the
JavaRanch Style Guide
subject: toget values from object table
Drop tables recursively
Getting error message - chapter 9 of ejb 3 in action using glassfish server 2.1
JPA-Hibernate One-to-One Bidirectional Relationship issue
HQL query required with left outer join
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014