(Jayaram Krishnaswamy) If you have ever loaded data into an Oracle table, you know that it is a rather complicated process. You will be surprised at how much easier it is to do in Oracle 10G XE. Keep reading to find out.

(Frank Zhou) This query alphabetically re-orders characters in a column.

(MS Sridhar) Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient.

(Dratz) When we talk here about recovering the database, we mean that one of two things has happened: your database has crashed because on an INSTANCE failure or because of a MEDIA failure.

Underscoring its commitment to provide customers with comprehensive, standards-based identity management capabilities, Oracle has announced the Oracle Enterprise Single Sign-On Suite, delivering enterprise authentication and single sign-on for mainframe, client/server and Web applications. The Suite

(Marcio Portes) This code uses the SQL Model clause to determine the first 12 elements of a Fibonacci Sequence.

(Lewis R Cunningham) Datatypes are a subject that confuses many people. There are many types and many sub-types. A type is a basic datatype like NUMBER. A sub-type is derived from a type. An INTEGER is a sub-type of NUMBER. A sub-type usually add a constraint to a type and that creates the new sub-t

This Confio white paper posits that database administrators need to be more concerned about Wait-Time than any other performance metric as they strive to meet stringent Service Level Agreements (SLAs). It builds a compelling case for using time-based analysis to rapidly identify the root causes of p

(Bill Brenner) Oracle Corp. fixed 65 security holes in its latest quarterly Critical Patch Update (CPU). The flaws affect a variety of products, including the vendor’s database and application server software. (R)

(Dratz) The Oracle architecture has one of the dumbest components new database professionals can imagine: rollback segments (known as UNDO in newer versions). –for those keeping score, I’m being a little sarcastic.