Pythian Group

Better late than never – we absolutely have prizes this year for the Blogger’s Meetup. Alex has been way too busy of late to get this organized (joking, not ALL his fault…). Seriously, we do have prizes. We will have beer and there will be food at Jillian’s in a very short time.

I gotta run and get this organized, so this post is short and sweet. Should be no complaints as this year we have not just two, but THREE prizes. Read on, or you’ll get the scoop at the meetup.

1) Bandana art contest on stylish Pythian & OTN designer bandanas — one lucky blogger will receive an Ipod touch generously sponsored by Pythian (we love this event, can you tell?).

2) For the best, most creative blog post about the meetup itself, OTN is giving away a free registration to Oracle OpenWorld in 2012. But, there are a few small rules:

1. the blog post must use as many names of people in attendance as possible.
2. the blog post must be readable. It needs to make sense to someone who wasn’t there. It must be a story and not a list.

Read the rest of this entry . . .

There was a discussion on the OTN General database forum, in which the OP asked creating a table with just one row and restricting that table to just one row. Here is my attempt at it.

I created a table with two columns, and the second column is a virtual column and contains a constant. I created a unique index on this column. On every insertion, this second column always evaluates to 1, and unique index (which become the function based index on virtual column) ensures that only one row remains in the table.

oracle@test # sqlplus /nolog
 
SQL*Plus: Release 11.1.0.7.0
 - Production on Sat Aug 28 19:09:16 2010
 
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
 
idle> conn test/test
Connected.
test@test> create table t1
 (c1 number, c2 generated always as (1) virtual);
 
Table created.
 
test@test> create unique index idx1 on t1(c2);
 
Index created.
 
test@test> insert into t1(c1) values (1);
 
1 row created.
 
test@test> commit;
 
Commit complete.
 
test@test> insert into t1(c1) values (1);
insert into t1(c1) values (1)
*
ERROR at line 1:
ORA-00001: unique constraint (TEST.IDX1) violated
 
 
test@test> insert into t1(c1) values (2);
insert into t1(c1) values (2)
*
ERROR at line 1:
ORA-00001: unique constraint (TEST.IDX1) violated

It’s that time of the year again — Oracle OpenWorld time — and it’s my pleasure to announce our regular Oracle bloggers meetup again this year. We all know that Oracle community has grown this year so we expect to see folks from all the different technologies including MySQL, Java, Sun hardware folks in addition to the core Oracle database and apps crowd.

So… all of you Oracle bloggers attending Oracle Open World 2010…
… you are invited to attend this Oracle Bloggers Meetup during OOW 2010 — a chance to meet your online buddies face-to-face in relaxed and informal atmosphere.

When: Wed, 22-Sep-2010, 5:30pm

Where: Lower Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103.
Read the rest of this entry . . .

I’m quite late to blog about it now but the OOW09 Bloggers Meetup was a success. I should say thanks to the OTN for sponsoring the bar tab as well as to HP for sponsoring a nice HP laptop as a prize.

The original location was a smaller area with a larger outdoor balcony but due to the weather concerns, it was moved completely indoor in the bigger banquet style room and it worked extremely well. We had more than 50 people showed up — probably around 70+ — as 51 t-shirts I printed for that occasion has completely gone.

The idea with t-shirt is to collect signatures from bloggers you meet and talk to. The most valuable result is that you get totally cool and unique t-shirt that you will want to wear after day (or maybe not wear and put it under the glad instead of the painting on the wall and demonstrate in your living room). The least all bloggers are going to do is to post a photo of their t-shirts — make sure you leave some feedback later.

Here is mine:

Read the rest of this entry . . .

As I’ve done my presentation this morning, I’m free for the rest of the day and I stopped by OTN Lounge where the cool stuff is almost ready to go — final tweaks and preparation before 4 days of rocking.

I’ve spoke to Justin Kestelyn of Oracle Technology Network and here what he has to say about this year’s OTN activities at the Oracle Open World. The keywords for me – “Espresso in the Morning, Beer in the Afternoon”.

Read the rest of this entry . . .