Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles

0
1
I accidentally locked myself out of my house this evening, and so I had to climb up the wall like a burglar and clamber in through a bathroom window, while the neighbourhood kids all watched and giggled, probably taking secret photos to share on Snapchat or something.  Embarrassing, yes, but what’s it got to do with Oracle? Well, the point… Continue Reading →Read more
0
1

JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2

0
0
In this sixth and final installment in this introductory series on JSON I’d like to revisit the question of generating JSON from your Oracle database. Cos it’s great to be able to consume a format; but if you can’t spit it out easily too you’ll probably want to look elsewhere. Easily, that’s the keyword in that sentence. In my previous… Continue Reading →Read more
0
0

Oracle for Absolute Beginners: Data Types

0
1
All databases stand on a tripod of datatypes: strings, numbers and dates. And so I’d imagine that by Day 2 or so of dabbling with Oracle you’d be starting to get reasonably comfortable with the VARCHAR2, NUMBER and TIMESTAMP data types. And that’s a good thing, familiarity with those three data types will take you a long way into a… Continue Reading →Read more
0
1

Oracle for Absolute Beginners: Date, Timestamp and Interval

0
2
All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy clothing – varchar2, clob, float, integer – strings are really just strings, and numbers are really just numbers. But dates — dates are interesting. In this article I’ll talk to you about dates, about time, and about how both are… Continue Reading →Read more
0
2

JSON For Absolute Beginners: Part 5 – Generating JSON in Oracle

0
0
In this fifth article in our series on JSON and the Oracle database we’ll be pulling the curtains back on the magic tricks that can convert your boring old relational data to JSON. OK, maybe that’s overselling it a little. Obviously there’s no magic involved; indeed some may say it’s anything but. But before we get to all of that,… Continue Reading →Read more
0
0

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

0
0
There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar with what JSON is and how it is created, and are only interested in discovering how to wrestle JSON data from an Oracle database, then you’re welcome, grab a seat. However, if you see the words JSON and Oracle, and… Continue Reading →Read more
0
0

JSON For Absolute Beginners: Part 3 – Storing JSON in Oracle

0
0
Welcome to part three in this series of articles about Oracle and its uneasy romance with JSON. Uneasy? Well, that’s a bit of a spoiler; so far it’s been smooth sailing. Part 1 was a precis of JSON, while Part 2 delved into the reasons for Oracle’s involvement in the area. So far so good; but now we’ve got to… Continue Reading →Read more
0
0

JSON For Absolute Beginners: Part 2 – Why Use Oracle?

0
0
In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database.  The first part was an introduction to JSON itself, and was, admittedly, very light on Oracle.  But now it’s probably time to bring Oracle more into the story and talk about how the database has adapted to handle this new format. Or, actually,… Continue Reading →Read more
0
0

JSON For Absolute Beginners: Part 1- Introduction

0
1
Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s for – something to do with data-interchange – perhaps you even suspect that the J stands for Javascript… or is that Java? The rise in JSON’s popularity has been pretty meteoric, from its early days back in the year 2001… Continue Reading →Read more
0
1

XQuery for Absolute Beginners: Part 5 – XQuery Update Facility

0
0
There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or updating? You cannae do both! But as, with each passing year, XQuery got more powerful and more popular the lack of an ability to modify XML documents began to look more and more like a gaping hole. And so, in… Continue Reading →Read more
0
0

XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions

0
0
This is the fourth part of a series introducing Oracle developers to XQuery. In the first three parts we’ve talked about XPath, Oracle’s implementation of XQuery, and FLWOR. This article won’t be taking on anything so meaty; I just want to clear up some odds and ends that I think are important, but I wasn’t able to shoehorn into any… Continue Reading →Read more
0
0

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

0
0
In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery and are looking to dip their toes into its world. If that’s you, hi, nice to meetcha. Or rather, nice to meetcha again. This is the second article in the series; go back and read the first if you haven’t… Continue Reading →Read more
0
0

Multi-Table Insert Statements in Oracle

0
2
We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming, one of them might read thus: Thou canst select from many tables, but thou may only update, delete from or insert into one table at a time. Right? Well, not exactly. Because you can actually add data to multiple tables… Continue Reading →Read more
0
2

Introduction to User-Defined Aggregate Functions

0
0
OK, let’s speed past the easy bits, the parts we all already know: standard aggregate functions. Aggregate functions, unlike regular functions, take values from multiple rows as their input. The category includes those aggregate functions that are so ordinary they’re almost invisible – SUM, COUNT, MAX – and a couple that most of us never use – such as APPROX_COUNT_DISTINCT…. Continue Reading →Read more
0
0

Introduction to Analytic Functions (Part 2)

0
0
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 more… Continue Reading →Read more
0
0

Introduction to Analytic Functions (Part 1)

1
2
Analytic functions have been part of Oracle for a very long time now – ever since 8i back in 1999. Analytic functions are an ANSI/ISO standard, and so you’ll find that they are similarly-implemented across a number of compliant databases. (This SQL Server article on “window functions” from sister site, Simple Talk, could very well have been talking about Oracle.) Analytic… Continue Reading →Read more
1
2