(Tim Quinlan) XML data is commonly used in today’s production systems and is a major part of database implementations. In the past, this fact caused design problems for database developers who consequently had to store, query, and update XML data as unstructured LOBs, or alternatively, “shred” data

(Chetan) Oracle has two types of Memory Structures: System and Program.

(Steve Callan) GUI interfaces into Oracle are becoming more and more common, and aside from the heavyweight TOAD, other products include SQL Developer, SQL Manager 2007 and SQL Edge. Inside of Oracle’s (free) SQL Developer 1.1 product is a tutorial, which includes a little bit about a lot of things

(Jayaram Krishnaswamy) In many cases, exporting a table to create an XML file is easy, but importing an XML file to create a table is much more difficult. This is true for Oracle 10G XE, as you will see in this article.

(Christo Kutrovsky) Many people would like to know how well their application will run in RAC. Would it be faster or slower? Would it run at all?

(Bob Watkins) Oracle’s START WITH and CONNECT BY clauses in the SELECT statement automatically traverse a hierarchy. Without this feature, a complex self-join would be required to identify which rows are logically related to others. The START WITH clause identifies the row or rows to be considered t

(Lydia Parziale, Kathryn Arrell, Dennis Dutcavich, Terry Elliott, Bruce Frank and Erik Kane) This IBM Redbook describe experiences gained while installing and testing several Oracle solutions, such as: –Single Instance of Oracle Database 10gR2 –Including sharing ORACLE_HOME and Cloning Oracl

(Lewis Cunningham) I have been playing with Oracle Streams again lately. My goal is to capture changes in 10g and send them to a 9i database.

(Mark Brunelli) Oracle is trying to make it easier for customers to license its products. (R)

(Tarry Singh) Since my last article, quite a few developments have taken place. Oracle has not only continued its onslaught on Red Hat but also opened up its own version of Enterprise Linux for download. Larry Ellison did mention in one of his older interviews that buying Red Hat would not add much