(Jeffrey Kemp) I needed to generate a random string with an exact length consisting of numeric digits, that I could send in an SMS to a user as a temporary account “pin”.

(Jsavit) The previous article in this series described Oracle VM domain types (HVM, HVM+PV, and PVM) and how to choose between them, discussed huge pages, and how to configure scheduling.

(Uwe M. Küchler) Today here’s a shorter post about my experiments with Oracle SQL Developer’s user-defined reports: A report on all long running operations (“LongOps”) with details on session wait events, explain plans and live SQL monitoring.

(Scott Wesley) In reality, this ‘add’ button could represent any action you would like in a report that would execute PL/SQL upon press of a row level button.

(Andrejus Baranovskis) ADF BC REST supports HTTP ETag to check for data consistency. This is common approach to implement caching and optimistic locking in REST. ADF BC REST relies on EO change indicator attribute, when change indicator attribute value is updated, new ETag is generated.

(Edward Orlowski) A while ago I decided to create an ADF page based on a dynamic table, and I found that, although there are quite some articles about the subject online, I still faced some challenges while implementing such a solution in ADF 12c. These challenges, however, can be solved easily when

(stewashton) At the UKOUG Tech15 conference, Jonathan Lewis presented a question asked on OTN and the answer published on his blog. The problem is how to count the number of rows in one table that fall into the ranges stored in another table.

(Agnes Freese) XSLT View is one of two graphical views provided by the new 12c XSLT Editor.

(Andrejus Baranovskis) ADF 12.2.1 ADF BC REST service is compatible with range paging mode of ADF BC View Object. Range paging generates SQL query with rownum to retrieve only a subset of rows to be returned to the REST service.

(David Fitzjarrell) Oracle 11.2.0.3 can still throw a curveball when it comes to LOB columns, notably with the SQL*Loader utility. Under the right conditions SQL*Loader can fail to load a table, throwing an ORA-08102. Let’s look at the issue to see what configuration can create that result.