ThatJeffSmith

Tag: list

Why I Don’t Follow You

A quick disclaimer: I was inspired to write this post after reading AmberIsMe‘s take on why she doesn’t read your blog. It’s not personal. Actually, it is a little personal. That is the point of social media after all, right? Building personal relationships with folks you admire that you wouldn’t otherwise be able to in [...]

Building your WHERE IN () Lists

Have you ever needed to write a query and filter your results with a WHERE EXISTS or a WHERE IN list of values? Your list will be comma delimited, and you’ll need to quote the strings appropriately. Not so bad if you have a few values, but what if you have 42 or 420 or [...]

Partitioning and DBMS_REDEFINITION

Unscientific research and Twitter gossip reveals that fewer than 15% of folks out there take advantage of Oracle’s partitioning (Oracle Docs) support for tables and indexes. Folks that build their own solutions in-house are more likely to discover and use partitioning. If you use a packaged 3rd-party database solution and it uses partitioning, then I [...]