As Published In

Oracle Magazine
May/June 2010

From Our Readers


Your corrections, your opinions, and your requests: Here’s your forum for telling us what’s right and wrong in each issue of Oracle Magazine, and for letting us know what you want to read.

More Than One

While reading “The Route to Success” by Steve Muench (Oracle Magazine, January/February 2010), I noticed that EmpView is executed without adding FindByEmpnoEnameOrJob view criteria. What about using just one bind variable, so that I needn’t call the NumberOrNull(Strings) method: 

( (Emp.EMPNO = :VarSearch ) OR 
(UPPER(Emp.ENAME) LIKE UPPER('%’ || :VarSearch || '%’) ) OR
 (UPPER(Emp.JOB) LIKE UPPER('%’ || :VarSearch || '%’) ) )

Karim H. Abdellatif
Karim.Hasan@meitweb.com

Steve Muench replies: The starter project should have the FindByEmpnoEnameOrJob view criteria already applied at the view instance level in the data model. I used two bind variables so that the bind variable used for the EMPNO equality comparison would be of type Number so that the EMPNO index could be used to find it.

Thanks for reading the column!

More Options

I have a digital subscription to Oracle Magazine . I will be receiving a Nook e-reader and wondered if I will be able to read the secured PDF on it.
Chris Barbo
cbarbo@jcpenney.com

The editors reply: The Nook does support PDF file types, so the Oracle Magazine PDF should work as well. You would need to download the PDF from the digital edition, then upload into the Nook for each issue.

More Like This

The interview with Sushil Kumar by Caroline Kvitka (Oracle Magazine, March/April 2010) was extremely insightful. I have shared it with several colleagues because I believe that Kumar’s interpretation of the cloud is very articulate. He did an impressive job clarifying where most others stumble.
Rob Tellone
rtellone@vbccloud.com

Regarding “Transparent Data Encryption” by Arup Nanda (Oracle Magazine, September/October 2005): If I could find articles for every Oracle feature that were this concise, it would sure make life as an Oracle DBA a heck of a lot easier. This was just what I needed.
Brian Strong
bstrong@impacservices.com

Arup Nanda replies: Thank you very much for the feedback. If I could get a letter like this for every article I write. . . . Letters such as this make an author’s day. Ultimately my articles are for the readers, and when readers provide the feedback that an article was beneficial to them, the effort proves all the more worthwhile. I am glad that you liked it and appreciate your taking the time to write about it.

More Possibilities 

E-Mail the Editors


Send your opinions about what you read in Oracle Magazine, and suggestions for possible technical articles, to opubedit_us@oracle.com. . Or click the Write the Editors link on our Website, oracle.com/oraclemagazine. You can also follow our @oraclemagazine Twitter feed or join us on Facebook. Letters may be edited for length and clarity and may be published in any medium. We consider any communications we receive publishable.

In “Tuning Your View Objects” by Steve Muench (Oracle Magazine, May/June 2006), Muench writes, 

If parts of your application do not need the functionality provided by entity-based view objects, you can improve performance by using a read-only view object instead.

Is the above still valid in Oracle Application Developer Framework (Oracle ADF) 11g, where the entity-object-level property Updatable can be set to false? Apart from a) declarative SQL generation in the ViewObject and b) reuse of attribute-level UI hints, what other benefits might read-only entity objects offer? Do read-only entity objects have an EntityCache?
Jangvijay Singh
jvsing@gmail.com

Steve Muench replies: Yes, this is still valid in Oracle ADF 11g . A read-only entity is similar to an entity all of whose attributes you have marked to be nonupdatable.

Send us your comments