SQL Navigator 6.7 released

Quest Software released the 6.7 version of SQL Navigator. Mainly it corrects some bugs.

Tracking code changes: the right way and the wrong way

Convert Excel Julian date to Oracle Date datatype

| May 7, 2012 13:09 +0000

SQL> select to_date(to_char(2415019+41029),'J') dd from dualDD      ———30-APR-121 row selectedWhere 41029 is the Excel Julian Date.

A long long proof

Decomposition of a relation into join of projections serves as motivation for database normalization theory. In relational lattice terms relation x projected into sets of attributes (that is empty relations) s and t:
x = (x v s) ^ (x v t)
Lets investig…

PL/SQL # Tip: Locally declared subprograms in PL/SQL

| May 7, 2012 08:38 +0000

Hi all, From long time, I am planning to start a blog section on PL/SQL programming tips. I have observed that as we grow more in technology, we skip some of the key features of language. When discovered later, the same tip appears to be an important b…

The problems with averages part 4: the average of averages != the real average

8 Interesting Things You May Have Missed This Week

| May 5, 2012 11:28 +0000

Oracle EBS File Comparison Report Now Available

How to read your (Microsoft Exchange) email using Oracle SQL and PL/SQL

PL/SQL Warning Messages in Oracle SQL Developer

10 classic mistakes that plague software development projects

How programmers c…

Update on InteliVideo

I’m making it easy for people to upload their content, create classes, and ultimately monetize their knowledge.

We all know that DVDs are going away. Everyone is watching movies on their iPads and iPhones now. You see kids watching movies at resta…

Poll: SQL Plan Management

| May 4, 2012 02:07 +0000

I’m interested in what SQL Plan Management features people are actively using.
For example on one system I’m working on, we use SQL Plan Baselines selectively, we have a couple of sql profiles as they were originally intended (i.e. as mechanisms fo…

The problems with averages, part 3: data may be skewed to one side of the mean

Display Errors with Zend

Someone asked how to display errors in the HTML output when they test PHP scripts with the Zend Server CE. Here are the two screen shots that help you enable the display of error and warning messages in your HTML display.

Click the Server Setup tab an…