(David Baum) Approaching Oracle’s Austin Data Center (ADC) through the open hills and plains of central Texas, you might initially mistake the nondescript stucco-clad facility for a traditional office building or warehouse. As you get closer and pass through the perimeter fencing, however, you r
Tag: Oracle
Oracle 10g Availability Enhancements, Part 4: LogMiner and Data Guard
(Jim Czuprynski) Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article – the final in a series – focuses on new functionalities provided by the Data Guard and LogMine
Counting Strings
(Potkin Nemat) This code tip shows the number of times a string is found within another string.
Building Web Applications with Oracle HTML DB, Part 2
(Michael Klaene) In last month’s article, “Developing Applications with Oracle HTML DB, Part 1,” we set up a rudimentary HTML DB application and deployed it to our workspace. To highlight the ease in which any developer, or non-developer with minimal SQL skills, could build something useful with thi
In enemy territory
(Martin Lynch) Oracle’s take-over of PeopleSoft has altered the enterprise applications market forever. SAP is still king of the enterprise resource planning (ERP) market by a good margin, but with Oracle’s new acquisitions, it may actually have to put up a fight to stay out in front.
Report Materialized View Log Entries
(Jay Zhang) Materialized Views (a.k.a. snapshots) are widely used in data warehouse and replication environments. For systems that use materialized views that are fast refreshed, it is necessary to create materialized view logs on base tables. If the number of entries in these log tables is too high
Connecting with Oracle – Ensuring Sufficient Privileges
(Steve Callan) If it has happened once, it has happened a million times, and that is getting the irritating ORA-01031: Insufficient privileges error. You can get this error even when you think you are in God mode as in the popular computer game Doom. Wouldn’t it be nice if Oracle had Very Happy Ammo
Oracle’s latest software focuses on enterprise application integration
(Bob Watkins) As recently as 2002, Oracle’s applications pitch was all about the suite: an integrated set of applications with a single, consistent data model. By contrast, the message at Oracle OpenWorld 2004 was all about integration. Oracle announced enhancements to E-Business Suite 11i and Appli
Containing Business Processes
(Alan Joch) Give a violin to a classical music master such as Itzhak Perlman, and he can single-handedly create a stirring solo. For a fuller sound, you might team him with an orchestra of world-renowned musicians. But no matter how accomplished the individual players are, a talented conductor is ke
Retrieve multiple Oracle Ref Cursor using .NET data Provider for Oracle
(Raghu Vangala) In my earlier article Multiple Result Sets in ADO.net using SqlClient ,we have seen how to retrieve multiple results using Sqlclient against SQL Server. This was a fairly simple and straight forward. We can achieve the same against Oracle database with a slight difference. We need to