I’m a heavy user and big fan of Bloglines. I use it as my main and only news reader. In addition to the fact that it is web based - which means I can access it from my home and work computer, after their recent data center move and upgrade, their feed update has been […]

Justin Kestelyn reports that the free Oracle Database 10g Express Edition is in production now. Woohoo! Thanks Oracle!

Now, waiting for Oracle SQL Developer to graduate

It looks like my blog’s feed, as well as OraQA and OraNA feeds are not being polled by Bloglines, and as a result new items have not been updated (in Bloglines only) for the past two or three days. They are all FeedBurner feeds.

If you subscribe to these feeds in Bloglines, you will see a […]

The NTILE function divides an ordered partition into buckets and assigns a bucket number to each row in the partition.

The buckets are calculated so that each bucket has exactly the same number of rows assigned to it.

If the number of rows in the partition does not divide evenly into the number of buckets, then […]

The number of bloggers blogging about Oracle and related technologies is on the rise. I have recently added the following blogs to OraNA:

Eric S. Emrick Jon Emmons Wijaya Kusumo Nitai Aventaggiato Marcos Campos Vadim Bobrov Marian Crkon Andy Campbell

A few weeks ago I wrote a post about how to Save/Download files to/from Oracle using ColdFusion. The example I used in the post was about saving Excel files as a BLOB in an Oracle table.

Today, I ran across an issue with file sizes greater than 244 KB. I was testing with a 7 MB […]

Steven Feuerstein has a nice post about Oracle GUIDs. In his latest product named Qute - the Quick Unit Test Engine, Steven uses GUIDs for primary keys.

Steven wrote about how a bug in the Delphi code and the fact that Oracle SYS_GUID function was returning sequentially-incremented values, rather than pseudo-random combinations of characters (in certain […]

I read that Pete Finnigan has created a new Oracle blogs aggregator. Since some of us are in this “blog aggregation” mood, let me introduce you to my Oracle blogs/news aggregator, OraNA. I have had OraNA up for a while and I have been using it as my Oracle blogs and news source.

Did you know that any executable statement in your PL/SQL code can be “labeled”. To label a particular section of your code just add <<your_label_name_here>> in front of that section. The label name cannot be more than 30 characters and has to start with a letter. No need to end the label with a semi-colon […]

First, Oracle HTMLDB was renamed to Oracle Application Express. Now, it looks like Oracle Project Raptor is going to be renamed to SQL Developer (Express?), as noticed in Sue Harper’s presentation at ODTUG.