OraNA :: Oracle News Aggregator

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

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

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…

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…

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…

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…

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…

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…