Category Archives: Oracle

Final Observations from OpenWorld 2008

So now OpenWorld 2008 is over, and San Franciscans rejoice as Howard Street reopens between 3rd and 4th, or at least it will soon.
I missed my Wednesday recap, since we spent Thursday sequestered in that same old conference room in Pleasanton. Not a lot happened for me on Wednesday.
Rich and I trolled the exhibit floors […]

Why Nashville!?!?! - Part 2

And now for part 2 of the events that led up to me moving to
Nashville…

I woke up on sunday morning and started to pack and get ready to
drive back to vegas. As I was getting ready I heart my email on
my iPhone go off so […]

Hey, we have a journeyman !

Congrats to Denes Kubicek for being the first journeyman on OTN.
OTN stars Justin and Nicolas (18954 and 15321 posts) do not get this title, as we Oracle Ace are sticked to our Ace logos. OTN upgraded the forums recently, many posts about this :
OTN Forums - Change the look and feel yourself
OTN Forums Update - […]

New RSS Feed for Oracle Database 10g Documentation Search

How do you create an RSS feed for a web page that does not have one? you use Dapper. That’s what I did with the Oracle database 10gR2 search result page. I used the Dapper generated RSS feed for this page in my oradoc Ubiquity command.
John already had an RSS feed for the 11g documentation […]

Oracle Listens Launches

Justin teased this earlier in the month, and today, Oracle Listens took over oracle.com.

I’m glad they overcame the hiccups that initially postponed its launch, and I’m nervously waiting for a flood of email to hit our support distribution list.
If you read here, you’ll remember that we’ve shifted our focus to Connect, our internal social platform […]

About case sensitivity

SQL is a case insensitive language. That means, you can write any SQL statement in uppercase or lowercase.

SQL> SELECT DUMMY FROM DUAL;
D
-
X

SQL> select dummy from dual;
D
-
X

Some formatters like Toad and some courseware like Skillsoft E-Learning advise to use UPPERCASE for commands and lowercase for tables and columns.

/* Formatted on 2008/09/19 10:00
(Formatter Plus v4.8.8) */
SELECT dummy
[…]

puzzled by Toad

one colleague just showed me how to insert duplicate rows in a table that has a primary key.

create table t(x number primary key);[F5]
Table created.
insert into t values (1);[F5]
1 row created.
insert into t values (1);[F5]
1 row created.

Hey, what happened? It took me quite a while to figure out which feature of Toad was “allowing” this.
Let’s […]

OpenWorld Continues

As is typical for me, the Monday of OpenWorld was the busiest. Now that it’s over, I can relax a bit. Yesterday was an action-packed day, so let’s hit the highlights. Roll the tape.
Our official session “Web 2.0 Technologies In the Enterprise: Lessons Learned, Tips, and Tricks from Oracle AppsLab” went pretty well. I’m not […]

Oracle Blogger Meetup and Oracle Ace Dinner Photos

In the past couple of days, I attended two special events. Here are the photos from the Oracle blogger meetup (Mohan has more here), and here are the ones from the Oracle Ace dinner.
I know that you want to put names on the faces. So, if you see yourself in any of the pictures, please […]

Executing PL/SQL from ANT - how to get the output

Javaddicts and the Amis blog are reporting about executing pl/sql statements from Ant: Executing Oracle PL/SQL from Ant, Executing PL/SQL from ANT - how to keep the format straight.
I’ve also written an Ant target for my current project where we execute pl/sql. The pl/sql queries domain values from some tables and outputs an xml document […]