Randolf Geist HAVING Cardinality When performing aggregate GROUP BY operations an additional filter on the aggregates can be applied using the HAVING clause. Usually aggregates are one of... 21 January 2013 2 min read
Jonathan Lewis Compression in Oracle – Part 1: Basic Table Compression In this short series on compression in Oracle, we will be looking at the various types of compression used by... 15 January 2013 12 min read
Patrick Barel Custom Authentication in APEX Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for... 09 January 2013 6 min read
Steve Harville Automating and delegating datapump imports with PL/SQL We recently bought another company and we are in the process of integrating our systems with theirs. One requirement was... 20 December 2012 2 min read
Marco Gralike Solving VMware network problems on Linux VMware guests When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware... 19 December 2012 1 min read
Kellyn Pot'Vin-Gorman Enterprise Manager Command Line Interface for EM12c This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a... 14 December 2012 2 min read
Wissem El Khlifi 11g Sql Plan Management I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the... 10 December 2012 1 min read
Jonathan Lewis Statistics in Oracle and SQL Server This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a... 10 December 2012 2 min read
Jan Leers Code Instrumentation Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to... 04 December 2012 5 min read
Gert Poel Generating XML from SQL and PL/SQL – Part 2 In this second part I’ll show you how you can generate XML from table data in PL/SQL. … 29 November 2012 10 min read
Patrick Barel Edition Based Redefinition – Part 1 One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality... 25 October 2012 7 min read
Jonathan Lewis Temporary Tables in Oracle and SQL Server This video is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please leave a... 15 October 2012 1 min read
Satishbabu Gunukula Convert Single Instance to RAC – Part 2: Manually Convert to RAC This article will focus on converting the single instance to RAC.… 10 October 2012 13 min read
Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part II In this second part we will setup the standby database and enable Fast Start Fail Over.… 27 September 2012 9 min read
Satishbabu Gunukula Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to... 20 September 2012 11 min read
Steve Harville Migrating a 2TB database to a new operating system with different endianness I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel... 19 September 2012 1 min read
Martin Giffy DSouza PL/SQL Exceptions Propagation during Variable Declaration It’s always good to know how any language handles and propagates exceptions, Oracle PL/SQL being no different. They’re plenty of... 11 September 2012 1 min read
Gert Poel Generating XML from SQL and PL/SQL – Part 1: Introduction From time to time you’ll have to represent your data stored in a database in an XML format, eg. to... 05 September 2012 5 min read
Patrick Barel Checking for NULL with Oracle SQL The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert... 30 August 2012 7 min read
Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part 1 Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases.... 07 August 2012 8 min read
