(Krishna Kondavadi) The objective of this function is to transpose rows to columns. This RowToCol function is built with invoker-rights AUTHID CURRENT_USER. The function works on tables/views of the user who invokes the function, not on the owner of this function.

The trim function removes all specified characters either from the beginning or the ending of a string. This article explains how to use the function in your scripts.

(Bill Burke) As the International Oracle Users Group conference, IOUG Live! 2004, in Toronto has come to a close, there’s no question in my mind that the 2004 IOUG Live! Conference Committee once again outdid itself in bringing our users group a first-rate conference experience. In every area–w

(Mark Rittman) The new data warehousing feature in Oracle Database 10g that has probably received the most attention is the SQL Model clause. The SQL Model clause allows users to embed spreadsheet-like models in a SELECT statement, in a way that was previously the domain of dedicated multidimensiona

(Boris Milrud) A common misconception among Oracle developers is they can run stored procedures in parallel only from outside the database. For example, many use Java-based code that spawns multiple Java threads and runs each procedure on a separate thread (using the java.sql.CallableStatement objec

(Arup Nanda) It’s New Year’s Eve. John, the DBA at Acme Bank, is reveling with his friends, counting down the arrival of the new year. Just when the clock strikes midnight and the crowd roars, his pager goes off. At the bank’s data center, during the end-of-the-year bookkeeping process in the in

(Arup Nanda) What tool do you use in your day-to-day DBA-related activities? It’s a question I asked recently in a user group meeting. The answers varied depending on the DBA’s work experience. Most senior administrators expressed a preference for simple command-line SQL*Plus (my personal favo

(Robert Westervelt) While many companies think they’re being proactive with security, too many are addressing security at the application level rather than the database level, according Oracle security expert Arup Nanda. Nanda, 32, a Norwalk, Conn.-based DBA who runs Proligence, an Oracle consultanc

(Marc L. Songini) Oracle Corp. users took stock of the company’s new 10g database, saying that the software’s automated management and self-tuning features could reduce the amount of drudge work they have to do. With 10g, Oracle has made strides in developing a database that’s easier to manage,

This article provides recommendations for tuning ORACLE on SPARC processor-based systems running the Solaris Operating System to minimize recovery in the event of a system or database failure. This article is relevant for any audience level.