corpus.blog
41,554 blogs · 4,819,422 posts Claim your blog
Back to seanstuber.com
Blog · corpus.blog/blogs/seanstuber.com/posts

seanstuber.com

seanstuber.com

2020

Upgrading to RAC and breaking jobs due to legacy instance affinityoriginal ↗
24 Jan 2020
A Timeline of Favorite Features in Oracleoriginal ↗
15 Jan 2020

2019

Setting up OpenLDAP on Oracle Linux 8 for TNS name resolutionoriginal ↗
29 Dec 2019
LDAP service name resolution package v2.2original ↗
26 Dec 2019
CQ Notification deregistration with javaoriginal ↗
21 Dec 2019
Licensing changes for Spatial and Advanced Analytics/Machine Learningoriginal ↗
5 Dec 2019
Is it a bug or a quirky feature?original ↗
4 Dec 2019
Password paper updateoriginal ↗
3 Dec 2019
Fixing missing application images in APEX with ORDSoriginal ↗
28 Nov 2019
SOUNDEX Alternatives Part 2: Dealing with NYSIIS Discrepanciesoriginal ↗
22 Nov 2019
SOUNDEX Alternatives Part 1: An unexpected twistoriginal ↗
21 Nov 2019
Dynamic SQL Templatesoriginal ↗
13 Nov 2019
SYS_CONTEXT DB_NAME bug fixed in 12cR2original ↗
12 Nov 2019
Time Zones, Daylight Saving Time, and DBMS_SCHEDULERoriginal ↗
10 Oct 2019
ROUND, TRUNC, CEIL, FLOOR for Numbers, Dates, and Timestampsoriginal ↗
21 Aug 2019
Bug in JSON_OBJECT with FORMAT JSONoriginal ↗
4 Jul 2019
Extracting APEX Access Control Usersoriginal ↗
7 Jun 2019
Using SQL*Plus scripting as a small data loader.original ↗
5 Jun 2019
DDL dump of multiple schemasoriginal ↗
22 May 2019
Simple sparklines with Unicode charactersoriginal ↗
24 Apr 2019
Goodbye to another great Collaborate.original ↗
11 Apr 2019
Java Table Functions – Returning a SQL collection from a Java function.original ↗
21 Mar 2019
Creativity vs Functionality – A Tale of a Query’s Developmentoriginal ↗
7 Mar 2019
A bug in the COLLECT function?original ↗
28 Feb 2019
Using Java stored procedure to read other databasesoriginal ↗
22 Feb 2019
Introduction to ASH Data, part 4original ↗
18 Feb 2019
Converting ISO8601 week-numbering text to dateoriginal ↗
22 Jan 2019
Introduction to ASH Data, part 3original ↗
21 Jan 2019

2018

Using collections to create variable parameter functions.original ↗
31 Dec 2018
Introduction to ASH Data, part 2original ↗
26 Dec 2018
Looking Through Holes in Timeoriginal ↗
18 Dec 2018
Introduction to ASH Dataoriginal ↗
27 Nov 2018
Simple Performance Diagnostics in APEXoriginal ↗
9 Oct 2018
Using MERGE to INSERT overlapping source dataoriginal ↗
19 Sept 2018
I’m not Steven Feuerstein, should I even bother blogging?original ↗
10 Sept 2018
How to use DBMS_LDAP (part 6: Modifying)original ↗
3 Sept 2018
Strange (erroneous) query from Oracle Audit Vaultoriginal ↗
1 Sept 2018
Updated Oracle password algorithm article for 18c.original ↗
7 Aug 2018
How to use DBMS_LDAP (part 5: Timeouts)original ↗
7 Aug 2018
How to use DBMS_LDAP (part 4: Attributes)original ↗
5 Aug 2018
How to use DBMS_LDAP (part 3: Searching)original ↗
1 Aug 2018
Unplug PDB from 12.2 CDB and Plug into 18c CDBoriginal ↗
29 Jul 2018
18.3 available for on-premises downloadoriginal ↗
23 Jul 2018
BACKUP_TYPE changes with 12c RMANoriginal ↗
21 Jul 2018
LTRIM, RTRIM, and TRIMoriginal ↗
18 Jul 2018
Toad 13 LDAP connection list not populating after upgrade to 18c clientoriginal ↗
12 Jul 2018
How to use DBMS_LDAP (part 2: Connecting)original ↗
8 Jul 2018
How to Use DBMS_LDAP (part 1: Introduction)original ↗
6 Jul 2018
My KScope2018 slidesoriginal ↗
23 Jun 2018
Partitioned Outer Joins – something old and new at the same time.original ↗
8 Jun 2018
Fast * Many = Slow, or, the Problem of Fast Codeoriginal ↗
24 May 2018
Timing is Everything, but Recording it is Even Betteroriginal ↗
6 May 2018
18c JSON TO_UTC_TIMESTAMP_TZ bugoriginal ↗
28 Apr 2018
Performance Diagnostics and Tuning With and Without Your DBAoriginal ↗
24 Apr 2018
Reading a PDF blob with PL/SQL and SQLoriginal ↗
16 Apr 2018
NULL vs NOT NULL columns and Index usageoriginal ↗
7 Apr 2018
SQL for the fun of it: finding typing patterns in words (Part 3 of 3)original ↗
4 Apr 2018
SQL for the fun of it: finding typing patterns in words (Part 2 of 3: using Model Clause)original ↗
3 Apr 2018
SQL for the fun of it: finding typing patterns in words (Part 1 of 3)original ↗
30 Mar 2018
Using Object Types: User-Defined Aggregates – CSV aggregation and uniquenessoriginal ↗
18 Mar 2018
Using Object Types: converting Text to Collections and Collections to Textoriginal ↗
18 Mar 2018
How big is a table?original ↗
16 Mar 2018
Who is using TEMP and what are they doing?original ↗
8 Mar 2018
Who is blocking whom and what are they doing?original ↗
5 Mar 2018
Oracle 18c Documentation is now available on OTN!original ↗
17 Feb 2018
Determining Endian format for your database serveroriginal ↗
10 Feb 2018
Using Object Types: ORDER member functionsoriginal ↗
28 Jan 2018
Using Object Types: MAP member functionsoriginal ↗
25 Jan 2018
Using Object Types: constructorsoriginal ↗
19 Jan 2018
Using Object Types: consolidating multiple valuesoriginal ↗
15 Jan 2018
MERGE, Triggers, and Statement Restartoriginal ↗
7 Jan 2018
My favorite database feature: the “Collapsing Index”original ↗
2 Jan 2018

2017

Oracle ACEoriginal ↗
30 Dec 2017
Unexpected change in CHR() functionality after upgrading to 12c.original ↗
29 Aug 2017
PBKDF2 in Oracle 12coriginal ↗
16 Aug 2017
How Oracle Stores Passwords article updated through 12.2original ↗
15 Jul 2017
How to pass a vector or data.frame from R to Oracle as a bind variable in a select statement using ROracle.original ↗
13 Jul 2017
Setting up the Star Schema Benchmark (SSB) in Oracleoriginal ↗
14 Jun 2017
Setting up TPC-H test data with Oracle on Linux (Part 2 – Large data sets)original ↗
29 May 2017
Setting up TPC-H test data with Oracle on Linux (Part 1 – Small data sets)original ↗
27 May 2017
12cR2 finally has on premises release!original ↗
2 Mar 2017
Nontechnical Skills Important To Being A Good Developeroriginal ↗
2 Mar 2017
Why does my code break with no changes and no invalid objects?original ↗
9 Feb 2017
Missing peaks in ASH resultsoriginal ↗
17 Jan 2017

2016

The Curse of “Expertise”original ↗
2 Aug 2016
Finding the name of an Oracle databaseoriginal ↗
30 Apr 2016
See you in Las Vegas!original ↗
9 Apr 2016
How Oracle Stores Passwordsoriginal ↗
20 Mar 2016

2015

Splitting a clob into rowsoriginal ↗
29 Oct 2015
Thank you, thank you, thank you!original ↗
27 Oct 2015
Only a few hours left in the Oracle Database Developer Choice Awardsoriginal ↗
15 Oct 2015
A day late but still funoriginal ↗
6 Oct 2015
Wow! I’m a finalist in the Oracle Developer Choice Awards!!!original ↗
17 Sept 2015
Using SQL to query USGS Data to monitor recent earthquakesoriginal ↗
28 Jul 2015
New version of LDAP package publishedoriginal ↗
16 Jan 2015

2014

Oracle optimizer doesn’t understand elementary mathoriginal ↗
18 Dec 2014
Book Review: Oracle PL/SQL Performance Tuning Tips & Techniquesoriginal ↗
7 Dec 2014
Update to LDAP packageoriginal ↗
27 May 2014

2013

Parallel PL/SQL with DBMS_PARALLEL_EXECUTEoriginal ↗
17 Oct 2013
Managing TNS lookups in OpenLDAP via PL/SQLoriginal ↗
24 Aug 2013
Previous Next