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
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!
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.
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.
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.
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.
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?
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.