(Jayaram Krishnaswamy) Oracle 10G XE provides a wizard to help you create a table. The wizard walks you through several steps for creating a table, taking you to the next step after you have entered valid entries for the current step. While scripts can be used to create a table, creating a table usi

(Bob Watkins) A database transaction is a unit of work that must either succeed completely or fail completely. In Oracle, a transaction starts with the first Data Management Language (DML) statement you execute, and ends when you issue a COMMIT statement to save the transaction or a ROLLBACK stateme

(Dan Hynes and Salil Pradhan) Although Service Oriented Architecture, or SOA, is still somewhat new, many companies are recognizing the need to adopt an SOA approach as a method of implementing solutions that are aligned with business needs. A key step in this approach is building out a portfolio of

(Julian Dyke and Steve Shaw) When designing a RAC cluster, you should fully define and identify your business requirements. Once you have defined your business requirements, your next step is to identify your architectural decisions, which will, in turn, allow you to specify storage and hardware req

(Arnoud Roth) Yesterday I needed to apply a patch to my Oracle E-Business Suite 11.5.10.2 environment.

(Ari Kaplan) Some vendors—and even customers—might think that there’s no story in storage. You have hard drives. You store data on them. End of story.

(Lewis R Cunningham) For some reason, the XMLType XPath implementation does not allow scalar results. According to the documentation: EXTRACT (XML) is similar to the EXISTSNODE function. It applies a VARCHAR2 XPath string and returns an XMLType instance containing an XML fragment.

(Sreeram Surapaneni) Oracle started shipping Standby Database features with the release of Oracle 8.0.4. Standby Database features were enhanced with the help of user feedback in subsequent releases of Oracle. Although there are several ways to set up highly available (HA) databases, including Oracl

(René Nyffenegger) I have recently stumbled upon something, which, after some thinking about, makes partially sense. The corpus delicti is a procedure that has an out parameter such as the following one.

Did you know the definition of document delivery has changed? Learn how a single solution with full Oracle integration allows you to not only automate business processes such as invoicing, sales orders and purchase orders in and out of your Oracle system, but also capture data, archive documents and