-
Automatically generate audit capture for tables
A weekend audit Often if you see the words “weekend audit” in a non-technical sense, it means that awkward moment where you look at the state of your house/bedroom/bathroom/bookshelf/shed etc and say to yourself “Yup, it is time we had a weekend audit of all this crap” But I had a different kind of weekend Read more
-
How to TREAT data in a CLOB as JSON
What better way to start a new week than with a cheesy title to my blog post! But there is method to my unstructured madness today as we talk about the TREAT function, available from 18C for JSON data. As many of us will already know it is possible to dive into JSON data and Read more
-
SQL tuning with Hashing and Sorting
Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that way. As soon as you have data, you will always have the need to aggregate it, and SQL is the perfect vehicle for that. I did a video recently which I will embed below that Read more
-
DDL gets my goat
First things first. If you are not familiar with the term “gets my goat” then you can find a definition here . But put simply, it means things that you find frustrating or bothersome. What is getting my goat today is the time it takes to get the DDL for a database object using the Read more
-
Completely free training for Oracle novices
At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database technology as well. But often, it is only once you enter the business world as you embark upon your IT career that you truly start to face the demands of enterprise-level data requirements. The small Read more
-
Upgrading…Its Time!
Gough Whitlam was an Australian politician who rose to power in the 1970s with the campaign slogan “It’s Time!”. Politics aside, it loosely ran on the premise that not to have the occasional dramatic change ultimately leads to stagnation in social and economic progress. The same analogy applies to the Oracle database. Of course, it Read more
-
How to generate random unique values
When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique numbers” then anyone with any experience of Oracle will more likely than not suggest a sequence. And that is good advice because a sequence is incredibly fast, scales well with multiple users, is very easy Read more
-
Why relying on default DATE formats is a bug
Today’s quick but important message is…don’t be lazy! Look….I get it If given the choice of typing: ’01-JUL-20′ or typing this: to_date(’01-JUL-20′,’DD-MON-RR’) then more often than not, we all are going to opt for the first alternative because we all can get lazy. But that reliance on the default date format mask in a session Read more
-
A better way of calculating Database space usage
It seems easy enough. An email pops through from your manager and he’s concerned about the space utilization in the database. Then comes the question: “So what exactly is using up most of the space?” For the sake of simplicity, lets assume that you already know that most of the space comes from a single Read more
-
MAX_STRING_SIZE and the data dictionary
This post cycles back too some other historical posts of mine related to max_string_size and the fact that the data dictionary uses LONG data type columns because of historical reasons related to backward compatibility. Most of us probably have existing databases that have gone through the standard upgrade through various versions of the Oracle Database, Read more
-
How to migrate to SECUREFILE with DataPump
These tweets somewhat befuddle me. Because to be honest, if I no matter if I say “Yes” or “No” , and then for someone to take that response at face value…well…whilst I’m flattered in the level of trust, I’m also a little saddened because I think our community is best served by everyone always insisting Read more
-
Take care with Read-Only partitions in 18c
The ability for part of a table to be read-only and other parts of the same table to allow full DML is a cool feature in the Oracle Partitioning option. Perhaps the most common example you will typically see for this is range-based partitioning on a date/timestamp column. As data “ages”, setting older partitions to Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 