If you are planning to migrate a database application from Oracle to PostgreSQL, this article can help you to understand and solve some of the issues occurring in such a process. PostgreSQL has recently become feature-complete in many areas and therefore porting projects from Oracle might be a feasible option in much more cases. Oracle […]
James Gosling, the creator of the original design of Java has resigned from Oracle a week ago. The news is anounced only now on his blog and confirmed by other sites (where you can find more details):
Context: – JBoss 5.1.0GA – Oracle9i Problem: During a long processing transaction, the ORA-02049 exception was thrown. Solution: According with metalink note 789517.1
Sorting characters is done differently from one language to another. For example, in English digits come before letters in an ascending sorting. But, in German, digits are ascendant sorted after letters. Sorting may or may not be case sensitive, diacritics may be considered or ignored, and phonetic rules could also be used (e.g.: in Spanish […]
In this article we will take a brief look at the Oracle SQL FIRST/LAST aggregate functions that allow you to select a value from the first or last row(s) of a sorted group, when the needed value is not the sort key. For example consider a table “PROJECT_COST” having the following structure and data:
One of my latest tasks was to install an application to a virtual machine, (running on a Vmware server). This application, built on client-server architecture, use an Oracle database so i had to install Oracle 10g and import the specific database for the application. Installing Oracle and make it work seemed to be an easy […]
By continuing to use the site, you agree to the use of cookies. More information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.