http://www.singlequery.com One is All You Need Mon, 21 Jul 2008 18:46:59 +0000 http://backend.userland.com/rss092 en  Overview In this example, we will demonstrate how Ajax can be use to efficiently populate a select list item in an Apex page on the fly “at run time”. Of course, this can be also done by using some simple JavaScript code BUT Ajax will be more efficient because it does not require ... http://www.singlequery.com/2008/07/using-ajax-to-populate-apex-items-on-the-fly/ I got a little press in the July/August 2008 edition of Oracle magazine about my presentation at Collaborate and I thought it would be prudent to shamelessly refer you to my presentation. Additionally, I will be presenting this same topic at the Northern California Oracle Users Group Summer Conference ... http://www.singlequery.com/2008/06/aces-in-the-hole-presentation/ Step by Step Guide for Installing a Data Guard/ Data Guard Broker Environment This focuses on setting up a test environment on a single node. The DBA can adapt this to set up a production environment. By Roger Lenihan Step 1: Install an Oracle database and validate it is in Archive ... http://www.singlequery.com/2008/06/step-by-step-guide-to-installing-a-dataguard-enviroment/ I just recently authored a PL/SQL Server Page designed to funnel large amounts of data via the htp.p function to a web application. Because the volume of data could be very large, I wanted to minimize the individual calls to the htp.p function (which can only take a maximum ... http://www.singlequery.com/2008/05/quick-hint-using-lobs-with-plsql-%e2%80%93-performance-problems/ I just returned from Collaborate 2008 in beautiful Denver, Colorado where I gave a presentation extolling the virtues of the OTN SQL and PL/SQL Forum as a learning tool for beginners and experts alike. The presentation was designed to both inform the audience about the incredible wealth of knowledge ... http://www.singlequery.com/2008/04/collaborate-2008-%e2%80%9caces-in-the-hole%e2%80%9d-presentation/ Greg and I will be speaking at IOUG Collaborate 08! Come hear us or the rest of the Piocon crew and stop by Piocon's Booth # 1619. Monday, April 14 Session 501 9:15 - 11:30 AM    Dan Norris and Matt Topper SSL, Load Balancers, Rewrite, Redirect and More Advanced ... http://www.singlequery.com/2008/03/collaborate-2008/ SingleQuery was out of commission for a short (actually, long!) while but we've fixed the issues and upgraded to Wordpress 2.5! Look for more posts soon. Jeremy http://www.singlequery.com/2008/03/wordpress-problems/ Pivot The Pivot clause is a new feature that has been introduced with the introduction of 11g.The simple logic behind the Pivot clause is that it enables the user to rotate rows into columns in the output of a query and at the same time enable the user to run aggregate ... http://www.singlequery.com/2007/12/pivot-and-unpivot-in-11g/ One of the big announcements at Oracle OpenWorld last week was Oracle VM. I'm a big fan of virtualization and have worked a lot with VMWare, but honestly I've never paid much attention to Xen (which Oracle VM is based on). Here's some item's I found interesting: Oracle VM (based on Xen) ... http://www.singlequery.com/2007/11/oracle-vm/ Dan and I were at a client whose custom OC4J Containers running in Windows 2003 SE on VMWare were crashing randomly. To make the situation more complex the default containers (Home and WebCenter) from Oracle were not crashing. Eventually we correlated the bulk of the OC4J crashes to admins logging out ... http://www.singlequery.com/2007/11/when-logging-off-crashes-your-oc4j-container/