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
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
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...
grassroots-oracle.com
Grassroots Oracle: Training
http://www.grassroots-oracle.com/p/training.html
Part of my duties at Sage Computing Services is to provide training, mainly in SQL, PL/SQL and APEX. We also offer training courses. In other core products. Review our complete course catalog here. I would like to suggest some key URLs to help you along your way, learning the Oracle tongue. Documentation index for major Oracle product releases. From this page you are one click away from 99% of the answers you'll ever need. Create snippets runnable in the browser, just like jsfiddle.net. Community reposit...
grassroots-oracle.com
Grassroots Oracle: My Social Network
http://www.grassroots-oracle.com/p/my-social-network.html
I'm not limiting this list to the major players - I'll also include other websites that may either display some form of profile of mine, a little brag, or somewhere you might be interested in participating/visiting/dabbling yourself. Occasionally I post something more than 160 characters in something labelled Thursday Thought. A regular jaunt for tangents. Sometimes there's some Friday Fun. And occasionally some science and other stuff. I also encourage you to join the offical APEX Group. 2) I'm someone ...
jeffkemponoracle.com
Forms Library – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other/forms-library
Oracle Database: Get it Right. Jeff Kemp on Oracle. Forms Library: PKG DEBUG. This is just a post to document a standard utility functions that I like to create in a Oracle Forms library, if equivalents are not already available. Suggestions or critiques are welcome. 8220;No warranty is express or implied about the suitability of this code for any purpose.”. This package could do with some improvements:. CREATE SEQUENCE DEBUG LOG SEQ;. CREATE OR REPLACE PACKAGE DB FORMS DEBUG IS TYPE logtable type IS TAB...
apex-de.blogspot.com
Rund um Apex (2) : Hide / Show von Spalten Inhalten im (Interactive) Report
http://apex-de.blogspot.com/2014/12/hide-show-von-report-bzw-spalten.html
Rund um Apex (2). Oracle APEX Tipps and Tricks - Fortführung von HTMLDB-DE.blogspot.com (link in der Navigation). Montag, 1. Dezember 2014. Hide / Show von Spalten Inhalten im (Interactive) Report. Whow, vor 9 (neuen! Jahren postete ich den ersten Eintrag in meinem. Und trotz des "alten Namens "HTMLDB" (aber jeder scheint es zu kennen) verirrten sich über 60.000 Besucher dorthin mit jede Menge Tricks und Tipps. Aber HTMLDB heisst ja nun seit der Version 2 (? Im SQL Statement erweiterte ich:. Mein Profil ...
SOCIAL ENGAGEMENT