(Eddie Awad) The join condition determines whether a join is an equijoin or a non-equijoin. An equijoin is a join with a join condition containing an equality operator. An equijoin combines rows that have equivalent values for the specified columns. When a join condition relates two tables by an ope

(René Nyffenegger) In my last blog entry, I have written a little Excel macro. This macro opens a connection to an Oracle database, issues a select statement and then iterates over each record within the result set. For each record, it also iterates over each attribute within this record.

(Benjamin De Boe) Fusion is hot, not only in many modern kitchens, but also at Oracle, where it means the synergy between our middleware and applications offering. As you might know, the next version of our eBusiness Suite, quite appropriately referred to as Oracle Fusion Applications, is being buil

You ever had a time when you wanted to run a SQL script, but the values it used had to change dynamically every time you run it? I sure have. Oracle itself (believe it or not) proposes two solutions to this task. One is to use the substitution variable marker & or the &&. What’s the difference b

(Edmon Begoli) Now continuing on my series of recommended technologies, specifically Native XML in relational databases. In this entry I will provide a closer look at Oracle 10g’s support for Native XML, or how they call it “XMLDB”.

(Daniel F. Savarese) Web application development presents a set of challenges different from those encountered in the development of self-contained desktop or server software. Whereas the interconnections between program modules in self-contained software are determined largely at compile time, the

(Joris Evers) Don’t even try to tell David Litchfield that Oracle is unbreakable.

Oracle promised to take the Linux software world by storm last October, but the major expansion by one of the world’s largest software companies so far has failed to show momentum.

(Renee Boucher Ferguson) Oracle is honing its focus on an area that is becoming near and dear to many corporations facing a daunting list of mandates and regulations: governance, compliance and risk.

(Robert Westervelt) A security expert is warning database administrators about a continued loophole in database communication protocols that would allow an attacker to bypass access controls and gain access to critical files. (R)