(Don Schlichting) A pivot is a data mining option typically used to transform large amounts data into a condensed list. Pivot style reports display data in a grid along a vertical and horizontal axis. Financial and managerial reports are the examples usually sited. The pivot style report pictured be
Other News
Padded Downloads
(John E. Simpson) The question would be almost Seinfeldian if it weren’t so hopelessly nerdy: what’s up with software descriptions, anyway? Did you ever notice how popular download sites A, B, and C always seem to provide exactly the same kind of information for a given software package? Are these s
Exception Handling in ASP.NET Application
(Rakheesh) Exception handling is one of the core areas where a software architect needs to concentrate during SDLC cycle. The importance of exception handling comes in the entire cycle of SDLC. During design time, designers have to forcast the type of the error that can be occurred in particular com
StringStream, Methods with Timeouts
(Stephen Toub) I’m trying to use a method that accepts a Stream as a parameter. However, the data I want to pass to that method is currently stored only as a string. Can you tell me what is the best way for me to pass the string to this method?
Oracle Analytic Functions: An Introduction
(Kailash Awati and Arati Apte) SQL is a compact yet versatile language – a surprisingly large variety of questions can be answered using standard SQL. However, certain classes of questions are extremely hard to answer using standard SQL.
Easy Web Templates with Oracle JDeveloper 10g
(Chris Schalk) In a simple manner, Web templates can be defined as: –Web page content—This is HTML or JSP content that could become complete Web pages or just portions of Web pages that contain often repeated Web content such as an HTML table containing an overall page layout, or portions of con
E-Business On Demand: A Journey, Not a Destination
(Kameron Cole) In the book/movie The Princess Bride, Inigo Montoya says, “You keep using that word. I do not think it means what you think it means.” Whenever I hear the phrase “On Demand,” I am haunted by Montoya’s words.
American Electric Power – Archiving Improves Application Performance
(Gary Girard) With more than 20,000 employees and more than $1 billion in annual revenue, American Electric Power (AEP) is the nation’s largest electricity generator, a leading wholesale marketer of energy commodities and a major U.S. electric utility.
‘Open Source’ Products a Growing Concern
The SCO Group’s controversial Linux-related lawsuit against IBM does not go to trial for another year, but the Utah company’s litigation already has corporate software buyers worried.
Use EXPLAIN PLAN and TKPROF To Tune Your Applications
(Roger Schrag) In this paper we’ll discuss an overview of the EXPLAIN PLAN and TKPROF functions built into the Oracle 8i server and learn how developers and DBAs use these tools to get the best performance out of their applications. We’ll look at how to invoke these tools both from the command l