(Jagadish Chatarji) This is the second article in a series concentrating on working with sub-queries in Oracle. My previous article (first in this series) explained the “dual” table in detail and gave a few practical examples of sub-queries. In this article, I shall introduce sub-queries at various

(Brian Peasland) I can’t get our database to start up correctly. I keep getting the following error. I have tried copying CONTROL02 to CONTROL01 and from CONTROL01 to CONTROL02 but it just always results in another error (ORA-01110). Our database is not in a live environment as we are in a testing p

(Shakir Sadikali) We’ve already established that I like broccoli. I get the taste from my dad who takes it with a glob a salad dressing and munches on it. It beats munching on Doritos. He and I both also do this with cucumbers. I don’t get it, but it tastes good and I know I’ll get a real kick out […]

(Samudra Gupta) The Summer 2006 release of the EJB 3.0 specification delivers a much simplified but more powerful EJB framework that demonstrates a marked preference for annotations over traditional EJB 2.x deployment descriptors. Annotations, introduced in J2SE 5.0, are modifiers that can be used i

(Raymond de Vries) When creating a Cube in OWB10g R2 one has the possibility to define aggregations to be performed for the Dimensions that the cube references.

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

(Alex Gorbachev) While reviewing some material in advance of my presentation at UKOUG Conference 2006, I found an interesting change in RMAN behavior in Oracle 10g.

(Sreeram Surapaneni) Today’s Database managers are more challenged than ever to find the appropriate tools and technologies for their mission-critical databases. When these databases are very large it requires a tremendous amount of effort to create a High Availability architecture that provides a c

(Deepak Vohra) In this article, you’ll learn how to use the FO Processor Engine, the XSL-FO Utility, and the PDF Document Merger. You’ll also get an overview of the Data Engine API, which generates an XML document from a database. The API uses an XML template to specify the SQL queries to the databa

(Bruno Vroman) Usually, when a view becomes invalid due to DDL work on the underlying table, its first usage (SELECT … FROM myview …) revalidates it, or it can be revalidated via “ALTER VIEW myview COMPILE;”. But sometimes a view remains invalid, such as when there is a bug. In a case like this,