November 2015

Pragma UDF – Speeding Up your PL/SQL Functions Called From SQL

A new feature for PL/SQL was introduced in V12, pragma UDF. UDF stands for User Defined Functions. It can speed up any SQL you have that uses PL/SQL functions you created yourself.

{please see this second post on some limitations of pragma UDF in respect of IN & RETURN data types and parameter defaults}.

We can create our own functions in PL/SQL and they can be called from both PL/SQL and SQL. This has been possible since V7.3 and is used extensively by some sites to extend the capabilities of the database and encapsulate business logic.

The power of metaphor

We had a question on AskTom the other day, asking us to explain what a “latch” was.

A simple metaphor sometimes does the trick Smile

 

metaphor

d3.js

Here is a short video

D3 Show Reel from Mike Bostock on Vimeo.

Here is a longer tutorial video

Data-driven Documents from London Web Standards on Vimeo.

Oracle Open World: Good News , Bad News

empty

Looking around Oracle Open World this year, it seemed like there was a significant drop in  attendees – at least compared to years past or especially compared to Dreamforce.  Feels like there is a lack of excitement. Makes me feel like Oracle has hit it’s apogee.

Twitter : Is it a valuable community contribution? (Follow Up)

There was some pretty interesting feedback on yesterday’s post, so I thought I would mention it in a follow up post, so it doesn’t get lost in the wasteland of blog comments. :)

Remember, I wasn’t saying certain types of tweets were necessarily good or bad. I was talking about how *I* rate them as far as content production and how they *might* be rated by an evangelism program…

Owning Your Content

Another thing that came out of my conversation with Zahid Anwar at OOW15, was about owning your content.

If your intention is to make a name for yourself in the community, it’s important you think about your “brand”. Most of us old-timers didn’t have to worry about this, and sometimes get a bit snooty about the idea of it, but we started early, so it was relatively easy to get noticed. For new people on the scene, it’s a much harder proposition.

It’s possible to write content on sites like Facebook, Google+ and LinkedIn, but I’m not sure that’s the best way to promote “your brand”. In some communities it might be the perfect solution, but in others I think you are in danger of becoming a faceless contributor to their brand.

Content in SCN

Nul points

(To understand the title, see this Wikipedia entry)

The title could also be: “Do as I say, don’t do as I do”, because I want to remind you of an error that I regularly commit in my demonstrations. Here’s an example:

 
SQL> create table t (n number); 

Table created 

Have you spotted the error yet ? Perhaps this will help:

NOUG Fall Training Day

Just a quick note to say that I’ll be speaking in Boston next week. Hope you can make it.

NOUG Fall Training Day

Datapump cleanup

Sometimes if you’ve been building data pump jobs via PL/SQL, you might get some part of it incorrect, and thus the job is left in the state of “DEFINING”, ie, you are building it but never managed to complete the process.  An interesting anomaly is that when this happens, your current session struggles to clean things up, ie,