jeffkemponoracle.com
Avoiding Lost Updates – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other/avoiding-lost-updates
Oracle Database: Get it Right. Jeff Kemp on Oracle. Category: Avoiding Lost Updates. Avoiding Lost Updates #3: The Solution. Background: see my earlier posts Avoiding Lost Updates. And Avoiding Lost Updates #2: Updateable Views. I’ve discussed this problem with my colleagues and have come up with a number of potential solutions, one of which we believe is bulletproof. Use ORA ROWSCN instead of version. Cause an update on the view to. Do at least one update of one of the non-outer-joined tables (even if i...
jeffkemponoracle.com
AUSOUG – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other/ausoug
Oracle Database: Get it Right. Jeff Kemp on Oracle. AUSOUG 2014 Perth Conference. It’s that wonderful time of year again – no, not talking about springtime, when I’m stalked by airborne grass pollens causing me to choke and gag all day. The sound of a lawnmower is enough to elicit a sneezing fit – and in Aussie springtime, that’s most weekends. The “wonderful time of year” I referred to earlier is that time when the excitement of OpenWorld has petered a bit and AUSOUG have released the program. If I wasn...
jeffkemponoracle.com
Tabular Form – set default values with jQuery – Jeff Kemp on Oracle
https://jeffkemponoracle.com/2015/07/22/tabular-form-set-default-values-with-jquery
Oracle Database: Get it Right. Jeff Kemp on Oracle. Tabular Form – set default values with jQuery. I tried basing the default on a hidden page item which I kept updated based on the values entered, but it seems the tabular form only gets the item’s value on page load and doesn’t re-examine the item’s value when you click the “Add” button. Instead, I had to turn to javascript and jQuery to get the job done. 1 Add a class to the tabular form column by setting the Element CSS Classes. July 22, 2015. Jochen ...
jeffkemponoracle.com
Presentations – Jeff Kemp on Oracle
https://jeffkemponoracle.com/presentations
Oracle Database: Get it Right. Jeff Kemp on Oracle. Slide decks and associated materials for talks I’ve presented. Building Maintainable Applications in Apex. 8211; presented at the AUSOUG Perth Conference, November 2014. Supplementary materials: Sample TAPI Application. Apex and Virtual Private Database. 8211; presented at the Insync Perth Conference, November 2013. PL/SQL Function Result Cache. 8211; presented at the AUSOUG Perth Monthly Meeting, June 2013. Old Oracle Versions – Top 20 Gotchas. I'm an ...
jeffkemponoracle.com
Other – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other
Oracle Database: Get it Right. Jeff Kemp on Oracle. You’ve finished the design for an Apex application, and the manager asks you “when will you have it ready to test”. You resist the temptation to respond snarkily “how long is a piece of string” – which, by the way, is often the only appropriate answer if they ask for an estimate. The design work has started. I plan all my projects using Trello. Recording estimates using the Scrum for Trello. My points system looks roughly like this:. 8220;6 weeks”).
jeffkemponoracle.com
Tools – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/oracle/tools-oracle
Oracle Database: Get it Right. Jeff Kemp on Oracle. Top 10 Reasons to Develop in a VM. If everything goes terribly wrong, simply restore to snapshot (duh, obviously). Handle shifting conditions outside your project. As often as I can (e.g. after a few weeks if a lot of development has gone on), I re-run the scripts on a VM based on a fresh copy of Prod – any changes that anyone else has made without my knowing it, which affect my scripts adversely, get picked up early. Drop a couple hundred tables? I can...
jeffkemponoracle.com
Auto-convert field to uppercase – Jeff Kemp on Oracle
https://jeffkemponoracle.com/2015/08/07/auto-convert-field-to-uppercase
Oracle Database: Get it Right. Jeff Kemp on Oracle. Auto-convert field to uppercase. This is just a quick note for my future reference. I needed all items with the class “. 8221; to be converted to uppercase, and I thought it would work with just some CSS:. Uppercase { text-transform:uppercase; }. This makes the items. Uppercase, but when the page is posted it actually sends the values exactly as the user typed. They’d type in “. 8220;, it looks like “. 8221; on screen, but gets posted as “. On TAPI Gene...
sagecomputing.biz
Sage Computing Services: About
http://www.sagecomputing.biz/about.html
Sage Computing Services We believe small creates big. Meet our team of Oracle specialists that care about the quality of their work and who really deliver. Penny is the founder and general manager of Sage Computing Services. Penny likes nothing more than tuning a badly written SQL query, teaching the latest Oracle concepts, presenting at user group events and travelling around the world. Penny is well known in the Australian Oracle community and the Australian Oracle User Group ( AUSOUG.
sagecomputing.com.au
SAGE Computing Services - About us
http://sagecomputing.com.au/about_sage_computing_services.html
There's no need to waste your development dollars by throwing them to an uninspired body shop. Why not meet our team at SAGE who are Oracle specialists that care about the quality of their work and who really deliver:. Penny is the founder and general manager of SAGE. Computing Services. Penny likes nothing more than tuning a badly written SQL query, teaching the latest Oracle concepts, presenting at user group events and bossing her team about. Having almost 15 years experience as an Oracle Systems Cons...
SOCIAL ENGAGEMENT