Who's online

There are currently 0 users and 27 guests online.

Recent comments

Oakies Blog Aggregator

OOW Bloggers

Pythian, in the guise of Alex Gorbachev, is organising the annual Oracle Bloggers meetup at Openworld, but if you qualify they’d like you to sign up.

Temporary Tables

After the success of the last Oracle/SQL Server discussion, James Murtagh of Redgate has arranged another online discussion – this time about the different ways in which temporary tables are implemented and used. As before I’ll be doing the Oracle bit and Grant Fritchey will be doing the SQL Server bit.

Update: Now that the event is over, you can listen to the recording at this URL.

While I’m advertising – there’s also some  news about CBO Days  (in Zurich,  Switzerland). Not only will I be speaking, but Maria Colgan and Mohammed Zait of Oracle Corp. will be speaking as well.  Maria is probably the best presenter I’ve ever seen talking about the optimizer, and Mohammed Zait probably knows more about it than anyone else in the world. Getting one of them to speak is terrific, getting both at once is a major triumph and leaves Trivadis with an event that is not to be missed.  (The other speakers, including me, are also pretty good)

WordPress 3.4.2 Released…

WordPress 3.4.2 has been released. You can see the bug fixes in the changelog and download from the usual place.

Happy upgrading. :)



WordPress 3.4.2 Released… was first posted on September 6, 2012 at 11:59 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle OpenWorld 2012 – Bloggers Meetup

Oracle OpenWorld Bloggers Meetup Oracle OpenWorld 2012 is just over a month away, and yes, we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld.

What: Oracle Bloggers Meetup 2012

When: Wed, 3-Oct-2012, 5:30pm

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 (street view). Please comment with “COUNT ME IN” if coming — we need to know the attendance numbers.

Traditionally, Oracle Technology Network joins Pythian sponsoring the venue and drinks.

As usual, vintage t-shirts from previous meetups will make you look cool — feel free to wear them. This year’s activity is still being planned — we have lots of cool ideas and can’t decide which one is the coolest. If you have something interesting in mind, let me know privately {last_name} at There will also be some cool swag for the blogger.

For those of you who don’t know the history… The Bloggers Meetups during Oracle OpenWorld were started by Mark Rittman and continued by Eddie Awad, and then I picked up the flag in 2009. The meetups have been a great success so let’s keep them this way! To give you an idea, here are the photos from the OOW08 Bloggers Meetup (courtesy of Eddie Awad) and last year’s meetup blog post update from myself.

While the initial meetings were mostly around Oracle database folks, the latest meetups are joined buy guys and gals from lots of Oracle technologies – Oracle database, MySQL, Applications, Sun technologies, Java, and more. All bloggers are welcome. This year we expect large attendance from the APEX meet up group as well. We estimate to gather around 150 bloggers.

See the results of last 2010 year’s meetup here and here. Follow all the links.

If you are planning to attend, please comment here with the phrase “COUNT ME IN”. This will help us make sure we have the attendance numbers right. Make sure you provide your blog URL with your comment — it’s a Bloggers Meetup after all! Make sure you comment here if you are attending so that we have enough room, food, and (most importantly) drinks. Last year we barely fit. Again, we are reserving a bigger room, but we want to make sure we can fit everyone!

Of course, do not under any circumstances forget to blog and tweet about this year’s bloggers meetup.

Speaking about blogging… The winner of last year’s competition on the best and most creative coverage introducing the most bloggers met at the meetup is… drum roll please… Bjoern Rost with the #oow11 blogger meetup blog post:

Looking forward to seeing even more of you again this year! Our big helpers this year are Vanessa Simmons and Maryanne Birksted behind the scene from Pythian marketing forces.

Null – again

Here’s a (camouflaged) constraint definition I came across a little while ago in a production system:

create table t1 (
	v1 varchar2(10),
	constraint c1 check (v1 = 'A' or v1 = null)

Quick question – will the following insert statement work or return an error ?

insert into t1 values('B');

The answer is that the row gets inserted – and that’s probably not an intended result.

It’s amazing how often NULL rears its ugly head as the cause of unexpected behaviour. Remember that a constraint accepts a value if the constraint does not evaluate to false. If you put ‘B’ into the constraint definition above, we get:

       'B' = 'A' or 'B' = null
hence   FALSE or NULL
hence   NULL

The constraint does not evaluate to FALSE, the row is inserted.

Apart from the possibility of unexpected data, there is a secondary problem with this constraint. Given that the programmer has created at least one constraint that indicates that he (or she) has explicitly tried to make NULL a legal option, does this mean that he (or she) thinks that every other constraint which doesn’t have a “col = null” check is implicitly going to stop NULLs appearing ? (Or, to say the same thing a little differently, did the programmer think that without this extra test the constraint would otherwise block NULLs).

Remember, if you want to block nulls in a column you should either declare the column to be NOT NULL, or include a constraint of the form “column is not null”.

Finally there’s one more problem – is this the only check constraint with this “= null” error, or are there a few more scattered around the system. So it’s time to search the data dictionary to find the rest (if there are any).

Oracle Security Search Is Annoying and protecting PL/SQL code

This post if not specifically about Oracle Security but I got here because of Oracle security so i am going to talk about Oracle security first...:-) I am working this morning on a proof of concept code for a security....[Read More]

Posted by Pete On 06/09/12 At 11:38 AM

Oracles Java Patch

OK, its not Oracle database security but its big news and it is from Oracle. Oracle have recently released an out of band Java security patch which supposedly fixed serious security flaws; then a few days ago the guys at....[Read More]

Posted by Pete On 05/09/12 At 12:11 PM

Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond

Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden daar gehouden, in vele tientallen zalen in hotels en het Moscone Conferentie Center in downtown San Francisco, waaronder pakweg 20 door Nederlandse sprekers. Hoewel honderden Nederlandse

Read More…

Oracle Open World 2012 – Oracle XML DB Presentations and Hands-on Labs

I hereby am following up on a small tradition, that I think I get going since 2006…An agenda overview of all things XMLDB you can do or see during this years Oracle Open World. Oracle Open World is the biggest IT conference nowadays in the world with 40.000+ thousand attendees and 1600+ sessions or workshops,

Read More…