(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
Tag: Oracle
Monitoring the Oracle HTTP Server
(Sam Alapati) You can manage the Oracle HTTP Server through the Application Server Control, or with the help of command-line tools.
Review: Oracle Performance Tuning for 10gR2, Second Edition
(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,
Interoperability between WCF and Oracle Application Server – Part1
(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.
Detect hierarchy loops with Oracle 10g’s new hierarchy pseudocolumns
(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
Sizing Up Performance
(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.
Oracle quietly releases E-Business Suite 12
(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.
Rule-based vs. cost-based optimization
(Brian Peasland) Please tell me the difference between rule-based and cost-based optimization of SQL queries, in detail. Thank you. (R)
How to Use Oracle Java XQuery API
(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.
Altering Oracle’s Value Returned for SYSDATE
(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.
