My session on "Oracle 12c for Developers" is done.Afterwards someone asks the question:
What happens when you use DBMS_REDACT with a complete row update?My guess was that it would place the redacted data in the column, but I haven't tried it, so here goes:
create table emp
,to_char (abs (dbms_random.random)) credit_card
(object_schema => 'A'
,object_name => 'EMP'
,policy_name => 'Hide Creditcard'
These techniques aim to be useful as well as fun to learn for (more...)
The big annual Oracle event is almost here – starting Sunday 28 Sep with the User Group Sunday followed by four days of presentations in around 50 tracks!
If the agenda seems a bit overwhelming, read the OTech Magazine Special OpenWorld Issue to find some of the highlights and can’t-miss sessions.
My sessions are:
- Mastering Oracle ADF Bindings: Advanced Techniques (UGF3484). Sunday Sep 28 at 10am in Moscone South room 270
- Starting Your Oracle Application (more...)
Apex 5.0 is going to be released in a couple of hoursIt's a long weekend here in Perth, and I have a footy grand final to watch - but no doubt I'll be installing it somewhere soon!
All that being said, apex.oracle.com is still on 4.2.5, so don't hold your breath for too long.
I’ve been setting up a simplified lab environment to let my students learn use in class. This added content will show them how to do reverse engineering with MySQL Workbench.
It’s a complete Fedora image with MySQL and Oracle Database 11g for the course. The uncompressed image is 14GB and the compressed image is 5.3GB. I chose Fedora because it’s the smallest open source image that supports both environments, and Fedora is the closest (more...)
Finally there is a real guide to OpenWorld - (more...)
I’m at Oracle Headquarters for pre-OpenWorld briefings this week, and am seeing many great things (that I’m not allowed to blog about yet
One thing that still puzzles me is that Oracle still don’t get social. They have very nice Social Network features (their product is called Oracle Social Network), but they insist on keeping this inside a walled garden with no integration to the outside world. In this, they are no different from (more...)
With dozens of ADF/Forms/Mobile/Cloud sessions planned for Oracle OpenWorld 2014, choosing which to attend can easily become an overwhelming task. Since I can relate to the chaos that occurs leading up to OOW each year, I thought I would make your lives a little easier by sharing my top ten picks of sessions to attend this year. (And to be frank it took me almost 4 days). Life requires too many decisions as it is, so (more...)
Now finally after a long period of waiting - and looking presentations and reading blogs I was able to do In-Memory databasing on my own. Having sampled some theoretical background how a a pure In-Memory Db works with SAP HANA; my expectations on the Oracle In-Memory Option were high. Also because Oracle promised it would work without code change, out of the box.
The Oracle database is located on Sun Solaris Machine (more...)
Originally posted on Oracle Data Warrior:
I just got this email from Amazon:
Congratulations, your book “UNA LISTA DE VERIFICACIÓN PARA REALIZAR REVISIONES A LOS DISEÑOS DE MODELOS DE DATOS” is live in the Kindle Store and is currently enrolled in KDP Select. It is available for readers to purchase here.
If you are in Mexico, you can get the book here.
If you are in Spain, you can get it here.
Somebody asked how to put PostgreSQL on my Fedora image with Oracle Database 11g and MySQL. It’s fairly simple. You can check for the current download at yum.postgresql.org and then download it like this as the
yum localinstall http://yum.postgresql.org/9.3/fedora/fedora-20-x86_64/pgdg-fedora93-9.3-1.noarch.rpm
You should see the following output when the download is (more...)
Both jQuery and Font Awesome are standard included with APEX5 (still in early adopter). With a little bit of jQuery you can create an animated button that reflects that it is doing something in the background.
For this example I created a button "Text + Icon button". Simply drag and drop this in the Page Designer.
The Icon CSS Class: "fa-play-circle-o"
and the action: "Defined by Dynamic Action"
For the Dynamic Action: it should respond (more...)
create table ...clustering by linear order (col1)
Almost two years ago, I wrote a little blog on how to trigger a Dynamic Action from a report. You can find that blog right here.
Things have changed with APEX5 (which is currently still in "early adaptor 2") which allow you to do this in a more clean way (or at least I think so). No need to create a "fake link" so the user know that the icon is clickable. No need to (more...)
|Larry Ellison 1978|
While I admit I'm far removed from the reality of the situation, I find it a little amusing how it's been deemed as a 'shake up' when a few paragraphs before he's quoted as saying this (referring to new co-CEOs)
“I am going to continue to do what I have been doing (more...)