Blog: Chris Saxon


209 blogs updated: 5 min. ago
Announcing the 2016 PL/SQL Challenge Championship for Database Design
In 2016, 340 people answered 6,185 quizzes in the Database Design quiz on the PL/SQL Challenge. I'm pleased to see so many people taking an ...
14
19-01-2017 18:37:24 Chris Saxon Oracle
12 Things Developers Will Love About Oracle Database 12c Release 2
It's here! Oracle Database 12c Release 2 (12.2) is available on Oracle Cloud! With it comes a whole host of new features to help you write b...
40
10-11-2016 23:26:17 Chris Saxon Oracle
12 Things Developers Will Love About Oracle Database 12c Release 2 INFOGRAPHIC
It's here! Oracle Database 12c Release 2 (12.2) is available on Oracle Cloud! Here's an infographic summarizing my 12 favorite features. If ...
34
10-11-2016 16:34:41 Chris Saxon Oracle
How to Convert Rows to Columns and Back Again with SQL (Aka PIVOT and UNPIVOT)
The Olympics is over for another year. But there's still plenty of time for SQL-style data wrangling of the results! To do this, I've compil...
35
08-09-2016 14:47:51 Chris Saxon Oracle
How to Recover Data (Without a Backup!)
Ryan McGuire / Gratisography It's the classic career-limiting maneuver: accidentally deleting data you weren't meant to. It's easy to do thi...
35
05-05-2016 11:46:36 Chris Saxon Oracle
How to Create an Execution Plan
When you're trying to get SQL to run faster there's one thing that's vital: an execution plan. In this post we'll investigate four ways to c...
60
22-03-2016 18:22:02 Chris Saxon Oracle
How to Find and Delete Duplicate Rows with SQL
There are some things in life it's great to have spare copy of. Your keys, your kidneys and your backups to name a few. Image by Ryan McGuir...
35
29-01-2016 19:35:52 Chris Saxon Oracle
Why You Can Get ORA-00942 Errors with Flashback Query
I've recently been playing with one of my favorite Oracle features: Flashback. More specifically, Flashback Data Archive. lightning last yea...
40
19-01-2016 11:35:54 Chris Saxon Oracle
Finding the Previous Row in a Different Group Using SQL
Imagine you have a table with a series of transactions. These are classified into credits or debits: TRANS_ID TRANS_DATETIME TRANS_TYPE AMOU...
35
06-01-2016 16:47:53 Chris Saxon Oracle
Creating Multiple Tables in a Single Transaction
The following quiz is taken from the PL/SQL Challenge. Can you guess which choices are correct? The Question Your boss has asked you to crea...
53
17-12-2015 13:12:03 Chris Saxon Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.