Articles tagged

08 May 2018
08 May 2018

utPLSQL 3.0 – How To Have Your Cake and Eat It

0
1
This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular refrain from the EU in the ongoing Brexit negotiations. They also seem to be a bit intolerant of “cherry picking”. I’ve never really understood the saying, “You can’t have your cake and eat it” – … Read more
20 February 2018
20 February 2018

Validating naming conventions in Oracle

0
5
Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of the source code. Defining these rules is one thing, but correctly and consistently applying them is another. Wouldn’t it be great if we were able to actually validate whether our team-specific naming rules have been applied the right way?… Read more
21 March 2016
21 March 2016

XQuery for Absolute Beginners: Part 3 – FLWOR

0
0
This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle developers interested in learning about Xquery. And – confession time – I’ve left the best part for last. However, you really should start with Part 1. Good things come to those who wait. In the first article we talked about… Read more
17 September 2015
17 September 2015

Introduction to Analytic Functions (Part 2)

0
2
In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to aggregate functions, and illustrated my points with a few examples. I demonstrated how, by clever use of the analytic function clauses – partition by, order by, and the windowing clause – you could tune your functions to wring even mor… Read more
05 August 2015
05 August 2015

Continuous Delivery for Oracle Databases, with Atlassian Bamboo and the Redgate DLM Automation Suite for Oracle (Part 1)

0
0
This post was originally published on Working With Devs. Welcome to part 1 in this short series, where I explain how to set up a continuous integration process for Oracle databases. In part 2 I’ll set up a release management process that allows a user to deploy changes to staging and live databases at the click of a button. Objectiv… Read more
25 February 2015
25 February 2015

Data Masking using SQL Loader

0
1
I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to do the same with our legacy Informix database but I found that we did not have the Database Gateway licenses required for using Enterprise Manager Data Masking Pack on Informix. We also had a requirement to replace customer names and… Read more
07 May 2014
07 May 2014

Oracle for Absolute Beginners: Part 6 – Procedures and Functions

0
29
A wise man once said, insanity is doing the same thing over and over again but expecting different results. If that is the case then no one’s saner than a computer programmer*, because programming is executing the same code over and over again and expecting the same results. We’ve already talked about bundling up statements in anonymous PL/SQL blocks; now… Read more
24 November 2013
24 November 2013

High Availability and SLA requirements for Oracle database

0
0
Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements. At the beginning of architecting a new high available Oracle database system it’s important to understand the need to make design and infrastructure decisions in the context of meeting Service Level Agreements (SLA). The SLA targets can be usually achieved… Read more
20 July 2011
20 July 2011

Working with Table Functions in PL/SQL

0
6
Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be queried like a physical database table. You use a table function like the name of a database table, in the FROM clause of a query. The difference with a physical database table in the FROM clause of the query is… Read more
23 July 2010
23 July 2010

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 to double-check that all of the planned modifications, and nothing else, have been deployed. An Oracle expert, Bruce Armstrong, comes across SQL Compare for Oracle, and sees if it helps with this time-consuming task.… Read more
24 June 2010
24 June 2010

Tom Kyte: Geek of the Week

Tom Kyte's contribution to the AskTom column and site over ten years has been outstanding. Much of what he says has relevance to all relational databases. His views are straightforward, the discussions he provokes are lively: Not only does he know a frightening amount about both Oracle and SQL Server, but he's also refreshing to listen to. … Read more