(José Valerio) Many times, experienced DBAs ask me how to make a cold backup to disk using RMAN, well the procedure is very trivial and explained below, use it at your own risk, its just provided for educational purposes.

(Bob Watkins) Oracle 10g introduced a replacement for the venerable DBMS_JOB package. DBMS_SCHEDULER has many benefits over DBMS_JOB, such as easier specification of start and interval times, and the ability to schedule operating system executables as well as PL/SQL. One of the best new features in

(Lewis Cunningham) What happens if you have a query with a user defined function in your select list that gets a NO_DATA_FOUND exception? Let’s try it. First we’ll create a simple function that will give us various results:

(Donal Daly) I hope most people know by now that Oracle Application Express (APEX) 3.0 has gone production, is available for download from OTN and our hosted instance, apex.oracle.com had also been upgraded to 3.0.

(ddelmoli) With apologies to the Beatles. I read a post by Tom Kyte the other day about a data model that had passwords as clear-text, unique keys on a table and even used them as foreign keys! After reading it, I was reminded of a conversation I had with my wife, Wendy, about how she’s seeing a r

(Rudy Limeback) How do I see distinct values of more than one column in a single SQL command? (R)

(Harm Verschuren) Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to the tracing stack: DBMS_MONITOR. This blog briefly describes with code examples how you could use DBMS_MONITOR to tr

(Marko Asplund) Oracle Text is a powerful search technology built into all Oracle Database editions, including the free Express Edition (XE). The development APIs provided by Oracle Text allow software developers to easily implement full-featured content search applications.

(Lawrence Linnemeyer and Bradley Brown) In this second part of a three-part article covering Oracle HTML DB, you’ll learn about common template sections and more.

(Peter Sayer) Oracle users have cancelled their user conference – with one month’s notice and no explanation.