Analytic Functions, which have been available since Oracle 8.1.6, are designed to address such problems as “Calculate a running total”, “Find percentages within a group”, “Top-N queries”, “Compute a moving average” and many more. Most of these problems can be solved using standard PL/SQL, however th

If you are creating database diagrams using the Oracle database server, you can take advantage of features specific to that server. Although the Database Designer is designed to work well with Oracle databases, there are some important differences in how the Database Designer works with Oracle datab

(Jim Czuprynski) Oracle Recovery Manager (RMAN) features have been expanded significantly in Oracle 9i. This article discusses several of these new features and includes examples on how to implement them to make any Oracle DBA’s backup, restoration, and disaster recovery plans more effective. Ora

This series of tutorials answers some frequently-asked questions about using the XML Parser for Java v2, part of the XDK for Java. Oracle XML Developer’s Kit (XDK) contains XML component libraries and utilities that you can use to XML-enable applications and Web sites. Oracle provides XML parsers

(Kevin Kline) This white paper is intended to give you a QUICK but thorough overview of the issues you may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle’s PL/SQL and Microsoft SQL Server’s Transact-SQL procedural extensions to the ANS

Building Java applications that use relational databases is perhaps the single most underestimated challenge in enterprise development today. More projects are delayed, under featured and difficult to maintain because of this underestimation. The problem lies with the use of fundamentally different

(Bruce P. Blackshaw) You would think that returning a JDBC result set from an Oracle PL/SQL stored procedure would be quite straightforward. Unfortunately, it’s not as easy as it sounds. But reading this article should tell you all you need to know.

(Robin Schumacher) “You can pay me now or pay me later” is a familiar phrase spoken by auto mechanics. Because of time and money (and sometimes just laziness) a lot of folks put off taking their car in for proactive maintenance work. The thing is, a little work performed over defined intervals in a

The to_date function converts a string to a date. Here’s an example of how it works.

(Jeff Hilts) Using Oracle as your database in the .NET environment is relatively simple, except when returning JDBC ResultSets from Java stored procedures. The Microsoft and Oracle .NET data provider drivers allow for easy access to data from SQL queries and PL/SQL stored procedures. There is not, h