Ellebæk Consulting

Blog

Learn about best practices for testing your Oracle code in the database, plus advanced tips for Oracle developers

Blog Post: Comparing Datasets

Blog Post: Copying/Transforming a REF CURSOR in Oracle 10g+

Blog Post: Describing a REF CURSOR in Oracle 10g+ Using PL/SQL, Java and C

Blog

Quest Code Tester for Oracle

Finn Ellebæk Nielsen blogged with Steven Feuerstein about automated testing of PL/SQL and SQL on Quest Software's official blog for Quest Code Tester for Oracle (Wayback Machine capture 19 Dec 2014) May 2009 through May 2011.

The blog Real Automated Code Testing for Oracle was part of Toad World. It was lost at some point in 2013 following the Dell Software acquisition of Quest Software in 2012. All the blog links on this page refer to the latest version captured from Wayback Machine (24 Apr 2013).

Blog Posts

Cached archive (fast)
Archived (slow)

Date	Title	Description
2011
02 May	Comparing Datasets	Best practices for comparing datasets with Quest Code Tester for Oracle
08 Apr	Oracle Database 11g Express Edition Beta Released	Oracle has recently released Oracle Database 11g Release 2 Express Edition Beta
03 Feb	Continuous Integration Part 2	How to deploy Test Definitions as part of a Continuous Integration Build process
2010
14 Dec	Installing Multiple Versions of Quest Code Tester	A few tips on how to handle installations of multiple QCTO versions on the same Windows client and the same Oracle instance
13 Jan	Continuous Integration	A short introduction to Continuous Integration (CI) and a description of how to integrate testing Oracle code with QCTO in a CI environment
2009
14 Sep	Test Amount	Best practices for determining test amount required through analysis of product risk
28 Jul	Test Approach	Best practices for a test approach that implements the policy and strategy for Oracle code laid out in a previous blog post
04 Jul	Test Policy and Strategy	Best practices for establishing a test policy, as well as a test strategy for Oracle code
17 May	Reasons for Testing Oracle Code in the Database	Reasons for testing Oracle code in the database
10 May	Code Tester Blog - Introduction	Steven Feuerstein introduces the new blog on Real Automated Code Testing for Oracle

Advanced Tips for Oracle Developers

Finn Ellebæk Nielsen blogs on advanced Oracle developer tips here: Finn Ellebæk Nielsen's blog.

Blog Posts

Date	Title	Description
2011
29 Mar	Copying/Transforming a REF CURSOR in Oracle 10g+	How to copy and optionally transform any PL/SQL `REF CURSOR` in a uniform way across all editions of Oracle Database from 10g Release 1 and newer
11 Mar	Describing a REF CURSOR in Oracle 10g+ Using PL/SQL, Java and C	How to describe any PL/SQL `REF CURSOR` in a uniform way across all editions of Oracle Database from 10g Release 1 and newer
25 Feb	Oracle Type Code Mappings	Type code mappings for Oracle data types across PL/SQL, Java and C
01 Feb	Comparing XML in Oracle	Comparing a specific type of XML documents with the purpose of obtaining details about their differences, within an Oracle database
27 Jan	Converting Between Oracle Data and XML	Various mechanisms for converting between Oracle data and XML, and vice versa
2010
06 Dec	Converting a LONG Column to a CLOB on the fly	A technique for converting Oracle `LONG` columns on the fly
06 Dec	Finn Ellebæk Nielsen's blog	Finn Ellebæk Nielsen has launched a new blog with advanced tips for Oracle developers


		OCP Advanced PL/SQL

		SCJP

		ISTQB CTFL