As I want later build Oracle docker images, some of this need a swapfile.
Per default my used Vagrantbox, does not have one, so later steps will fail.
As in the last blog I use a Vagrant shell provider.
# add swapfile to the box
config.vm.provision :shell, :path => "add_swap.sh"
This calls the script add_swap.sh in the created VirtualBox machine.
Make sure, that you create your swapfile on a supported (more...)
set last_posting_date = date'2016-08-18';
It’s been a while since I’ve published here. You see, I’ve been kind of busy.
Back in January 2015 I was lucky enough to join Oracle as part of their Developer Advocate team. My focus is SQL.
You see I love working with SQL. And I love helping others. So joining the Developer Advocates was a great chance to combine these passions :)
Which leads some to ask:
Why is your site (more...)
If you need to send almost any message to almost any phone from your Oracle database, and you want to use straight PL/SQL, you may want to consider using my Clicksend API.
- SMS (Short Message Service)
- MMS (Multimedia Message Service)
- Text to Voice
I have released the first beta version of my Oracle PL/SQL API for Clicksend. Read the installation instructions, API reference and download the release from here:
Sending an SMS is as (more...)
More specifically do we still need to worry about data modeling in the NoSQL, Hadoop, Big Data, Data Lake, world? This keeps coming up. Today it was via email after a presentation I gave last week. This time the query was about the place of data modeling tools in this new world order. Bottom line: […]
Do you need to accept payments for goods and services via your (APEX) application and would you prefer to handle the payments in the database via PL/SQL? Then this blog post is for you... :-)
Almost a decade ago (in 2007), Oracle released a whitepaper on Integrating Application Express with PayPal Payments Pro
which used PayPal's Name Value Pair (NVP) API.
In the years since then, PayPal has made available a new API which is (more...)
As I want later build docker images and run docker containers I have to provide enough disk space for this.
Per default the Vagrantboxes have vmdk disks, these have a static size and are to small for my purposes.
Therefore I convert the disk, which comes with the box, via Vagrant VirtualBox provider from vmdk to vdi, so that it allocate only the used disk space in the host system.
Additional I add a second (more...)
You all know Oracle OpenWorld, right? It's a behemoth of a conference filling up the streets and hotels of San Francisco with many thousands of people moving like ants between conference rooms, checking out exhibitors, hanging around lounging areas, networking, talking, listening, eating, drinking, learning and having fun. And it happens every year...
Each year it seems to get tougher and tougher to become accepted as a speaker at OOW - Oracle needs to reserve (more...)
As I want to decouple my development server from my computer as much as possible I want to create first a virtual machine with linux.
Because I have used Oracle Virtualbox in the past successfully, I will use it here too.
As I want have later a reproducible environment via Infrastructure as code, I give Vagrant a try for this. As source code management system I use GIT, my remote repository is located at CloudForge.
We are excited to announce AuraPlayer has been shortlisted for UKOUG’s 2016/2017
Digital Transformation Partner of the Year! This award provides recognition to Oracle Partners for their contributions to Oracle users by promoting digital transformation.
It has been such an incredible year watching our customer’s applications change from gray screens nailed onto a desktop to cutting-edge mobile applications. Digital transformations have been occurring in all industries including field service, public-sector and retail. We are so (more...)
and Todd Hershiser gave me some very valuable feedback through their comments on my recent "Splitting Strings" posts. The big news is: PL/SQL beats SQL!
In my previous post
to split a comma delimited string. Now I'll apply that technique to multiple rows, and show that it's faster than other methods.
hat vor kurzem einen interessanten Artikel zu einem Thema veröffentlicht, mit dem man sich beim Schreiben komplexerer SQL-Queries regelmäßig herumschlagen muss: dem Vergleichen von Spalten, in denen NULL-Werte auftauchen können. Für die Prüfung der Gleichheit von Werten bedarf die korrekte Behandlung von NULL-Werten bereits eines recht sperrigen Ausdrucks:
column1 = column2 or (column1 is null and column2 is null)
Und noch unhandlicher wird der Ausdruck, wenn man die Ungleichheit von Werten prüfen möchte:
In my post New, Improved IN Lists!
, I split one string into multiple rows. Now I want to split multiple input strings - but first, I've rediscovered an even faster technique!
Warning: this is based on the Apex 5.1 Early Adopter and details may change.
The standard File Upload item type is getting a nice little upgrade in Apex 5.1. By simply changing attributes on the item, you can allow users to select multiple files (from a single directory) at the same time.
In addition, you can now restrict the type of file they may choose, according to the MIME type of the file, (more...)
Some time ago I was asked to assist in fixing or at least finding the cause of a performance problem. The application ran fine until the Virtual Private Database (VPD) policy was applied. Oracle claims there should be near zero impact on your application when you implement VPD, then how is this possible?
First of all, the policy applied was a rather complex one. A complex query should be executed to determine if the current (more...)
Unlike my lengthy posts, this is really a quick one. Alright, so how do you get to know when your materialized view got refreshed? Well, no biggies. There are bunch of dictionary views who capture refresh date but none of them give you timestamp. For fast refresh, you can work with SCN or timestamp based MView … Continue reading
I was constructing a fresh app for a presentation idea and I came to think about the prefix people use for Application Items in Oracle APEX.
I've seen a few variations used, and upon asking the question on Twitter (as a poll limited to 4 options), some came back with a few other suggestions.
The final tally based on the replies (we'll (more...)