Back to Basics: The Art of Conversation
Articles
Written by Patrick Donlin   Introduction In a digital age, social and business networking sites, job boards, tweeting, blogging etc., provide untold volumes of information that must be sifted, sorted and assessed before becoming usable in a meaningful way.  Engaging your network through personal face-to-face conversations is a dying art, and one that is unmatched in the quality of information gained, plus it’s a lot more fun!   Today’s World Today we seem to be inundated with technology that facilitates constant communication with our friends, colleagues and clients.  There is no doubt that Blackberries, iPhones, iPads, laptops, and the like …
Collections in PL/SQL: An Introduction
Articles
Written by Bob Watkins, Managing Partner of B. Watkins Collections are an essential tool in PL/SQL programming. In this article, we’ll take a look at what collections are, why they’re important, and how to declare and use them. What are collections? Collections are datatypes that you use to declare variables in your PL/SQL program. Unlike built-in datatypes like NUMBER and VARCHAR2, collection datatypes are user-defined: you must first declare them, give them a name, and decide how they are structured.  Then you can declare variables based upon the new datatypes. Oracle defines a collection as: “an ordered group of elements, …
Data Guard for Dummies
Articles
Written by Charles Kim,  Oracle ACE and an Oracle Certified DBA Data Guard provides a simple solution to protect your data.  Data Guard maintains standby databases as transactionally consistent copies of the production database. These standby databases can be located at remote disaster recovery sites thousands of miles away from the production data center, or they may be located in the same city, same campus, or even in the same building. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, thus minimizing the downtime …
Holiday Xmas Wishes
Articles
Written by Mary Elizabeth McNeely, DOUG President An Oracle Christmas Song Sung to the tune of “The Twelve Days of Christmas” On the first day of Christmas, My true love sent to me An index that’s a b-tree. On the second day of Christmas, My true love sent to me Two raw devices, And an index that’s a b-tree. On the third day of Christmas, My true love sent to me Three corrupt blocks, Two raw devices, And an index that’s a b-tree. On the fourth day of Christmas, My true love sent to me Four TKPROFs, Three corrupt blocks, …
Application Express: The Power of APEX Interactive Reports
Articles
Written by Ricky Burke, Oracle Architect and Instructor Oracle Application Express (APEX) is a free development tool for the Oracle database.  Using only a web browser and limited programming experience, you can rapidly develop and deploy professional, scalable and secure web-based applications. APEX is easy to use, flexible and highly productivity.  No client-side software installation is necessary, and when configured with the XML DB HTTP server built into the Oracle database, there is no need for a separate web server. One of the best features of Application Express is the new Interactive Report.  This article starts by covering the complete …