(Jean-Marc Rosengard) PL/SQL programs are organised in functions, procedures and packages (somewhat similar to Java packages). There is a limited support for objectoriented programming. PL/SQL is based on the Ada programming language, and as such it shares many elements of its syntax with Pascal. (

(Dave Wotton) How Oracle rollback segments work is a widely misunderstood concept of the Oracle RDBMS, and consequently the “ORA-01555: snapshot too old” error message strikes fear into the hearts of Database administrators and SQL programmers alike. This web page tries to explain the cause of this

(Robert Westervelt) Oracle Corp. highlighted its relationship with Red Hat and announced the formation of a Linux Test Lab to experiment with its software on the Red Hat and Novell SuSE Linux operating systems, as well as the mainline Linux kernel. (R)

The Oracle by Example series provides step-by-step instructions on how to perform a variety of tasks using Enterprise Manager 10g Grid Control. The Oracle by Example series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are buil

(Tanel Poder) Lots of production downtime can be eliminated by using prepared software stack for upgrading. That means, we take the software stack of the latest successfully completed test upgrade and will carry out production upgrade with the same software as well. That means we don’t have to apply

(Kelly Shermach) Prior to Oracle’s announcement of its PeopleSoft integration road map, there were rumors that it would shed J.D. Edwards & Co., a business purchased by PeopleSoft in 2003.

(Alexander Bubernak) The most importing thing in collecting trace data is collecting properly scoped data. You should know the application and user interaction. Collecting too little data can point you in the wrong direction. Collecting data in the middle of a performance problem or long wait wi

(Ravi Kumar Buragapu) This document describes on a unique mechanism and process that enable to make use of Oracle references cursors in Java Database programming in developing highly scalable business applications with greater performance. (pdf)

OracleConnection objects that experience errors because sessions or connections are dropped are returned to the connection pool when the Connection.Close method is called. Then, the OracleConnection objects are reused. This may cause unexpected behavior.

By attending this webcast, delegates will gain an understanding of how to upgrade their Oracle databases with minimal downtime, using Quest Software’s solutions. Attend this webcast and discover: –How to achieve minimal downtime even when upgrading hardware or moving to a new operating system