Nick Buytaert in Oracle

Validating naming conventions in Oracle

Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of...

20 February 2018 8 min read

Oracle

Aman Sharma in Oracle

Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking

Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.…

03 February 2017 8 min read

Oracle

Aman Sharma in Oracle

Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing

In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help...

20 January 2017 9 min read

Oracle

Aman Sharma in Oracle

Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics

Oracle parent and child cursors explained - how the library cache shares SQL execution plans across identical statements while maintaining...

12 December 2016 11 min read

David Njoku

JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle

There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar...

03 October 2016 11 min read

Oracle

Aman Sharma in Oracle

Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

Oracle SQL query parsing explained - the query processing workflow from SQL statement to execution plan, the difference between hard...

05 September 2016 16 min read

David Njoku

XQuery for Absolute Beginners: Part 3 – FLWOR

This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle...

21 March 2016 9 min read

David Njoku

XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database

In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery...

02 March 2016 7 min read

David Njoku

Introduction to Analytic Functions (Part 2)

In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to...

17 September 2015 7 min read

Steve Harville

Data Masking using SQL Loader

I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to...

25 February 2015 5 min read

Randolf Geist

Parallel Execution Skew – Addressing Skew Using Manual Rewrites

In this part of the series we will have a look at different approaches to how Parallel Execution Skew can...

23 June 2014 13 min read

David Njoku

Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers

A wise man once said: start at the beginning and go on till you come to the end: then stop....

10 June 2014 9 min read

David Njoku

Oracle for Absolute Beginners: Part 6 – Procedures and Functions

A wise man once said, insanity is doing the same thing over and over again but expecting different results. If...

07 May 2014 13 min read

Kirill Loifman

High Availability and SLA requirements for Oracle database

Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements....

24 November 2013 1 min read

Oracle

Patrick Barel in Oracle

Oracle Virtual Private Database (VPD) Part 2: Advanced Policy Options and Data Redaction (12c)

Oracle Virtual Private Database (VPD) advanced policy options and Data Redaction - additional DBMS_RLS.ADD_POLICY parameters for fine-grained access control, and...

04 September 2013 9 min read

Michael Sorens

TortoiseSVN and Subversion Cookbook Part 11: Subversion and Oracle

It is only recently that the tools have existed to make source-control easy for database developers. Although entire build-scripts for...

03 April 2013 17 min read

Richard Morris

Kohsuke Kawaguchi: Geek of the Week

Jenkins, formerly called Hudson, is an open-source server-based Continuous Integration tool that works with all the major Source Control Management...

17 July 2012 11 min read

Patrick Barel

Working with Table Functions in PL/SQL

Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be...

20 July 2011 2 min read

David Njoku

Readying your Oracle Database for Your First Apex Application

APEX can be a great way to create an application rapidly on an Oracle Database. Although it is generally straightforward,...

14 June 2011 9 min read

Bruce Armstrong

Product Review: Schema Compare for Oracle

One of the more important tasks in the process of rolling out incremental developments to a multi-server production system is...

23 July 2010 11 min read

Register for Simple Talk

oracle

Validating naming conventions in Oracle

Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking

Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing

Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics

JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle

Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

XQuery for Absolute Beginners: Part 3 – FLWOR

XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database

Introduction to Analytic Functions (Part 2)

Data Masking using SQL Loader

Parallel Execution Skew – Addressing Skew Using Manual Rewrites

Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers

Oracle for Absolute Beginners: Part 6 – Procedures and Functions

High Availability and SLA requirements for Oracle database

Oracle Virtual Private Database (VPD) Part 2: Advanced Policy Options and Data Redaction (12c)

TortoiseSVN and Subversion Cookbook Part 11: Subversion and Oracle

Kohsuke Kawaguchi: Geek of the Week

Working with Table Functions in PL/SQL

Readying your Oracle Database for Your First Apex Application

Product Review: Schema Compare for Oracle