(Vincent Chan) The ever increasing demand of sharing, consolidating and synchronizing critical enterprise data and the ability to provide secondary access to updated information without compromising production system performance require a technology like Oracle Streams.
Tag: Oracle
Using DCSS/XIP with Oracle 10g on Linux for System z
(Lydia Parziale, Bruce Frank, Tom Russell, Barton Robinson and Tony Noto) Linux on IBM System z offers many advantages to customers who rely upon IBM mainframe systems to run their businesses. Linux on IBM System z takes advantage of the qualities of service in the IBM System z hardware and in z/VM
Adding Google-like Search Operators to Simple Search Boxes
(Nick Bollweg) The range of search activities performed by the average user is large and growing. In fact, your users are probably spending more time searching in some applications than actually using the results they find there. So how do you make your information more easily available, increasing
Open source shapes up as rival to Oracle
(Candace Lombardi) Oracle continues to dominate the database software market, but challenges lie ahead from open source, analysts say.
Introduction to Basic SQL, Part 3 – Complex Joins and Sub-queries
(Lewis R Cunningham) In my previous article, I covered SQL Joins with two tables. Today, I will cover joining tables with three or more tables and using sub-queries to join. I’ll also throw in some details about the UNION clause and show other places a sub-query might be used.
De-duplicate tables using Oracle’s analytic functions
(Bob Watkins) Tables that don’t have a Primary Key constraint protecting them can have duplicate rows inserted into them. The traditional way to locate such duplicates is with a query using the GROUP BY and HAVING keywords. After grouping the data on the key columns and counting the rows in each gro
Oracle OpenWorld 2006 Overview
Oracle OpenWorld 2006 is the world’s largest event dedicated to helping enterprises understand and harness the power of information. Connect with the people, products, and trends at the forefront of business and information technology in San Francisco. (R)
Learning to Query in Oracle XE
(Jayaram Krishnaswamy) Querying the database is one of the most common tasks that you may have to carry out routinely. This tutorial shows you the options for running SQL queries and how to run the queries against the database in the Oracle Express Edition, Oracle XE for short.
Introduction to Basic SQL, Part 2 – Joins
(Lewis R Cunningham) This is an article I wrote last year for Suite101.com. I’m no longer posting there so I decided to post this and the next entry (part 3) here. That way all of the starter stuff I’ve done is all in one place. You can read Learn Oracle – What is Oracle? and an Introduction to SQL,
Oracle Takes Aim at SAP Customers
Oracle plans to set up a Solution Support Center for R/3 support providers to help them run the SAP applications on Oracle databases. The company says the support services Systime will offer could cost 55 percent less than SAP charges.
