Articles tagged oracle

08 May 2018
08 May 2018

utPLSQL 3.0 – How To Have Your Cake and Eat It

0
2
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
6
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
13
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
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
44
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
14
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