The BLOB


"Have you ever heard a blindfolded octopus unwrap a cellophane-covered bathtub?"
-- Norton Juster, The Phantom Tollbooth

An interesting question was posted on the Oracle General Database forums fairly recently, inquiring about creating a B-Tree index on a BLOB column to speed queries looking for NULLs in that BLOB. The conventional wisdom states that, because it’s a BLOB, NULLs shouldn’t be present. And because it’s a BLOB, containing binary data, creating sucn an index (more...)

Riga Dev Days 2017, new experiences in many ways.

Riga Dev Days 2017

General

It has been a while since my last blog-post.
One of the reasons is my shift from closed to open source software, databases more specifically. More on that in a later blog-post.

The reason for already mentioning this is this strange hybrid (what a popular word, these days) situation that I am in at the moment.
Thanks to the super enthusiastic, flexible and tenacious organization-team of the Riga Dev Days, (more...)

Adjusting Things


"The only thing you can do easily is be wrong, and that's hardly worth the effort." 
-- Norton Juster, The Phantom Tollbooth

Query tuning is both an art and a science and, because of this, usually occurs on a case-by-case basis. There may be occasions, though, where a series of queries, similar in structure and differing in predicate values, need to be tuned. Rather than go through each and every query, setting up a (more...)

OracleCode London 2017

My colleague & boss Ace Director Luis Weir and I where invited to present at Thursday 20th’s Oracle Code London.

oracle_codeThe request to present came late as we where needed to cover someone who had to cancel (not that we aren’t grateful for the opportunity). This did mean getting the presentation together was a little bit of a scramble, unfortunately I missed a couple of sessions as I needed to assemble an environment, work out how (more...)

eAdam 3.0

Source: eAdam 3.0


Developer Experience: How Do We Improve

Introduction

In the first part of this series I introduced the concept of Developer Experience and why I think it is important that we start investing more into improving the Developer Experience.  In this part I will lay down some foundations on how this could be done.

The pillars of DX

Know your user (i.e. the developer)

Not all developers are alike.  You can see this within a company like Oracle: developers in the DataBase group (more...)

Developer Experience: What and Why

Introduction

For the past 2 years I have been trying to raise awareness of the concept of Developer Experience (DX) both inside and outside Oracle.  Over the next few days I will release a couple of blog posts delving deeper into this subject.  This first post will concentrate on what DX is and why I feel it is important that we invest in it.

What is Developer Experience

The concept of Developer Experience has existed for many years. (more...)

Who Likes Me?

In my previous entry, Fun with Facebook, I described how to pull data from Facebook’s Graph API Explorer, organize it using NodeBox, and turn it into representations of friends, posts, and the “likes” that connect them. Here is the final result:

The final “Who Likes Me?” poster

The above image is a snapshot of a high-resolution poster with many fine details. One of my goals for this project was to create (more...)

Fun With Facebook

I am often surprised by which of my Facebook posts are the most liked and by who likes what. I wondered: are there any interesting patterns there? Could I visualize them?

My next question (as always) was: could I get the data? Thanks to the rise of  the API economy I could. Companies have discovered it’s profitable to make their private data public. IT departments are splitting into private and public-facing sides. Public APIs (more...)

GDC 2017: A Push toward Ethical & Accessible Alternate Realities

Raymond and I were fortunate to attend the Game Developers Conference this year. Compared to the previous year, the crowds were calmer and new sessions and summits were added to accommodate growing interests in VR and UX.  This year there seemed to be more focus on delivering (a) Inclusive and Accessible experiences as well as (b) building out Virtual, Augmented and Mixed Reality experiences.

The State of VR

Before we talk about about AR/MR and building (more...)

Oracle Code Behind the Scenes

The Oracle Code (@oracledevs) event series is going to 20 cities around the world, showcasing many Oracle Cloud Service offerings.

Oracle Code coming to a city near you!

The event at each city will have keynote sessions from various speakers, demo stations showing many of Oracle’s Cloud services, a code lounge for developers to check out some “hardware” linked and controlled through Oracle backend, and other partner booths.

AppsLab has been actively involved in these (more...)

Installing Oracle 12c Release 2 Database on a Proxmox Container

Obviously nobody could beat Tim to getting the comprehensive installation instructions out first, but here are my notes for installing it on a proxmox container environment which is what I use as my research platform. Some of the calls used are from or based on Tim’s prior 12cR1 installation article – thanks Tim.

NOTE – this post is just a guide and is based on my environment – you will likely need to make changes to (more...)

#Oracle cutting in inspiration and new business?

Over the many years Oracle has been leading the database world, I guess they are now taking something of a wrong turn.
Let me briefly fill you in on my thoughts.

Basically I see two “minor” shifts that are significantly indicative of this:

  1. Oracle Standard Edition 2
  2. Oracle ACE Program

Okay, so you might think I am crazy, but let me try to explain.

Oracle Standard Edition 2

Sometime last year, the long expected, (more...)

Password validation takes a while, how cool is that!!

You log in to your favorite web app and it takes a little while to get your login validated, or your password consumed, depending on your take on things,
or
You log in to your favorite APEX application, and after every 3rd shot, it takes a bit longer to retry

You are sure what you are doing and you are surely not drunk, but just mistyped the ****-password.

It is annoying, but is it?

I (more...)

UKOUG Tech16 Presentation Slides, Apex & Oracle Cloud

My presentation for UKOUG Tech 16 can be seen by following the link – Introduction to SOA CS. or see below   It was a tremendous 4 days (if you include the Tech stream’s Super Sunday).  If you are a UKOUG member and didn’t make it to the conference I’d look out for the material to be become available.

Whilst I’m not a big Apex fan (stitching business logic into the persistence layer feels wrong (more...)

UKOUG Oracle Scene – Another Article Published

The latest edition of the UK Oracle User Group (UKOUG) Oracle Scene Journal is out now with another article from me, in addition to some great content from other contributors. This article builds upon and updates an article previously published in the Oracle Apps User Group about 18 months ago. We updated and republished as part of the run up to the UKOUG special Event in March next year which will be fully announced at (more...)

Oracle 2 Minute Tech Tip

The Oracle Technology Network (OTN) promote/encourage people to submit short videos as 2 minute tech tips – you can check my 1st attempt out …


PLS-00801: internal error [hshuid:LU invalid] when compiling a package body

This was a strange one.  Attempts at recompiling the following package body resulted in this PLS-00801 error. COL owner FOR A20 COL object_name FOR A40 BREAK ON object_name SELECT owner, object_name, object_type, status, created, last_ddl_time FROM dba_objects WHERE object_name = 'PKG_FINANCIALS_WORK' ORDER BY status, object_type / OWNER                OBJECT_NAME    

Read More...

Installing Oracle 12c Client

It's very important to have your SQL client to take full advantage of your local PeopleSoft installation. In this step-by-step tutorial, I will show you how to get your SQL Developer up and running in minutes.

How to Install PeopleSoft on Your Laptop

If you want to have your own local PeopleSoft installation, look no further. This post shows you exactly what I did to install PeopleSoft 9.2 / PeopleTools 8.54 on my Windows 8.1 laptop using Oracle VM Virtualbox.