Tag Archives: regex

Via Twitter, an interesting regexp_replace puzzle

Prolific and knowledgeable Oracle Ace LewisC asked a regular expression (more specifically, regexp_replace) question on Twitter, and I found myself thinking, “hey, I bet I could actually answer that!” So I did. Then I thought about my answer a bit more, and decided to write a blog post to expand upon my original 140-character response.

Clearing the Oracle environment in a Unix session

Correctly defining Oracle-related environment variables in a Linux or Unix session is pretty important, especially on a system that hosts multiple ORACLE_HOMEs. Equally important is making sure that old settings are removed from the environment when switching contexts from one ORACLE_HOME to another. Here’s an example of how I do it.