Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we query a VO?

user8654007Jan 3 2012 — edited Jan 3 2012
Hi all,

I am working on doing some optimizations in my sql queries.

My table is huge and out of which i frequently just need some data. What i thought is i can create a vo on the big table and get only the small data in vo which i need frequently.

But next question is can i do the queries on the data available in VO???

Lets say in java i extracted the VO at run time and i got the VO object now if i want something like " select * from jamVO where JamID = 1" where jamVo is the insiance of the oracle.jbo.ViewObject.

Is it possible to do it in any ways?

Regards,
Batra

Edited by: user8654007 on Jan 2, 2012 11:20 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 31 2012
Added on Jan 3 2012
5 comments
506 views