(René Nyffenegger) I have been playing with Excel and its Visual Basic for Application (VBA) macros recently. As much as I loathe the syntax of VBA, I do like what can be done with it. Especially, I found it quite easy to connect to an Oracle Database with ADODB, execute a select statement and impor

(Sam Alapati) You can manage the Oracle HTTP Server through the Application Server Control, or with the help of command-line tools.

(Steve Callan) Within Oracle, performance tuning (sometimes referred to as performance and tuning) is by far one of the hardest subject areas to master. There are no shortcuts to being good at tuning an Oracle database, but there certainly are a lot of tools and advice covering the specifics of how,

(John Charles Olamendy) This article is part of series intended to show how to use Web Services related technologies to interoperate applications running in different platforms, in this case, the most common scenario between Microsoft.NET and Oracle AS platforms.

(Bob Watkins) In a previous tip, I described how to sort the entries in a hierarchical query. For a hierarchical query to work, however, the data must not loop back upon itself. That is, a parent row may not list itself or one of its child rows as its own parent. If this were the case, Oracle could

(Mike Hichwa) As Oracle Application Express becomes more popular, many users are asking for guidance on sizing and performance tuning. In this column, I’ll show you a quick and convenient way to estimate performance and sizing. I’ll also demonstrate how to identify and deal with performance issues.

(Nancy Gohring) Oracle Corp. has quietly released E-Business Suite Release 12 to customers a few days in advance of a big launch event planned for next week in New York City.

(Brian Peasland) Please tell me the difference between rule-based and cost-based optimization of SQL queries, in detail. Thank you. (R)

(Anghel Leonard) This code outlines the main steps involved in using the Oracle Java XQuery API (OJXQI). If you are familiar with the DataDirectXQuery – XQuery for Java (DDXQ-XQJ), you may notice a some similarities.

(James F. Koopmann) If you have ever tried to do testing for applications that was time sensitive and thought you had to change the operating system time to change the date and time, try this method.