Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Mike

Pages: 1 ... 103 104 [105] 106 107 ... 144
PSOUG / Re: REGEXP_SUBSTR Function usage
« on: August 10, 2011, 03:15:36 PM »
Hmmm...this would be easy to solve in a second-tier language like PHP, Java, perl, etc, but I'm not sure of the best way to do this in SQL. You might have to do some preprocessing of the string to split it along the delimiter and then examine the values. I'd bet there's a better/cleaner way to do it via SQL but I'm not aware of how that would be done.

Another way might be to use regexp to look for the digits and key off of them. Something like "(/d+)" or "(/d*)" might work.

Thanks Mike.

I am aware of the technical differences between empty and null. Sorry for mixing these terms. In this case, Oracle considers thel ack of a substring to be NULL.

If I choose the value 5 (because I want the fifth substring) as shown below, it returns a single row with a null value instead of the value '3301'. As mentioned before, I must use 3 as the occurance to get the fifth substring '3301'. This will become a problem when the third or fourth substrings become populated.

REGEXP_SUBSTR( '001.069012...3301', '[^.]+', 1, 5 ) RESULT



PSOUG / Re: REGEXP_SUBSTR Function usage
« on: August 10, 2011, 02:14:07 PM »
Hmmm, I'm not totally up on the finer points of REGEXP_SUBSTR, but here are a couple of ideas...

First, what happens when you have empty substrings
- does it throw an error. or...?

Second, you're probably aware of this, but NULL and empty aren't the same can test for NULL, but an empty string would return "not null" if you tested one.

I am attempting to extract substrings out of a string (ex. '001.069012...3301').
From the sting I wish to treat the period (.) as the delimiter. As such there are 5 substrings in this string with the third and fourth having a null value. I am currently using the following code to do this:


This code (which I got off of this wesite, Thanks Mike!) works great as long as there are no empty (null) substrings in the string.
Right now in order to get the 5th substring, I am actually using 3 for the occurance arguement.

Any suggestions on how to get this to work so it can handle empty (null) substrings?

Side note: for those of you familiar with MUMPS, this would work like the $PIECE function.

Thank you for a great website Mike. You have lots of great content here! :-)

Podcast: Thomas Erl and Anne Thomas Manes - Part 2 of 3

Erl and Manes discuss how to deal with SOA foot-draggers and the impact of cloud computing on SOA.

Oracle News / WARNING: Dont use Java 7 for anything
« on: July 29, 2011, 01:32:48 PM »
Java 7 GA was released today, but as noted by Uwe Schindler, there are some very frightening bugs in HotSpot Loop optimizations that are enabled by default. In the best case scenario, these bugs cause the JVM to crash. In the worst case scenario, they cause incorrect execution of loops.

Bottom Line: Dont use Java 7 for anything (unless maybe you know you dont have any loops in your java code)

From: Uwe Schindler
Date: Thu, 28 Jul 2011 23:13:36 +0200
Subject: [WARNING] Index corruption and crashes in Apache Lucene Core / Apache Solr with Java 7

Hello Apache Lucene & Apache Solr users,
Hello users of other Java-based Apache projects,

Oracle released Java 7 today. Unfortunately it contains hotspot compiler
optimizations, which miscompile some loops. This can affect code of several
Apache projects. Sometimes JVMs only crash, but in several cases, results
calculated can be incorrect, leading to bugs in applications (see Hotspot
bugs 7070134 [1], 7044738 [2], 7068051 [3]).

Apache Lucene Core and Apache Solr are two Apache projects, which are
affected by these bugs, namely all versions released until today. Solr users
with the default configuration will have Java crashing with SIGSEGV as soon
as they start to index documents, as one affected part is the well-known
Porter stemmer (see LUCENE-3335 [4]). Other loops in Lucene may be
miscompiled, too, leading to index corruption (especially on Lucene trunk
with pulsing codec; other loops may be affected, too LUCENE-3346 [5]).

These problems were detected only 5 days before the official Java 7 release,
so Oracle had no time to fix those bugs, affecting also many more
applications. In response to our questions, they proposed to include the
fixes into service release u2 (eventually into service release u1, see [6]).
This means you cannot use Apache Lucene/Solr with Java 7 releases before
Update 2! If you do, please dont open bug reports, it is not the
committers fault! At least disable loop optimizations using the
-XX:-UseLoopPredicate JVM option to not risk index corruptions.
Please note: Also Java 6 users are affected, if they use one of those JVM
options, which are not enabled by default: -XX:+OptimizeStringConcat or

It is strongly recommended not to use any hotspot optimization switches in
any Java version without extensive testing!

In case you upgrade to Java 7, remember that you may have to reindex, as the
unicode version shipped with Java 7 changed and tokenization behaves
differently (e.g. lowercasing). For more information, read
JRE_VERSION_MIGRATION.txt in your distribution package!
On behalf of the Lucene project,


Interview: Thomas Erl and Anne Thomas Manes - Part 1 of 3

SOA gurus Erl and Manes talk about their latest book, “SOA Governance: Governing Shared Services on Premise and in the Cloud.”

Oracle Announces Availability of Java SE 7

Java SE 7 has been released! It includes Project Coin, the new Fork/Join Framework, the New File System API (NIO.2), InvokeDynamic and more.

Article: The DBA’s Guide to Setting Up Oracle RAC One Node and Oracle Data Guard

With these guidelines, using Oracle RAC One Node in conjunction with Oracle Data Guard for disaster recovery is a straightforward task.

Oracle Java SE Critical Patch Update Advisory - June 2011

Oracle Critical Patch Update (CPU) Advisory - July 2011

Oracle News / OTN Headlines Oracle VM VirtualBox 4.1.0 Released!
« on: July 19, 2011, 11:45:02 AM »
Oracle VM VirtualBox 4.1.0 Released!

Oracle has released Oracle VM VirtualBox version 4.1 today. Unlike last week's maintenance release on our stable 4.0.x branch, today's 4.1 release introduces some exciting new cutting edge features.

Effective Resource Management using Oracle Solaris and Oracle ...

Comparison of Oracle Solaris Resource Manager and Oracle Database Resource Manager, how they work together in a consolidated environment (Oracle Solaris plus Oracle Database), with a focus on managing high-availability resources.

Technical Article: Caching Strategies for Oracle Service Bus 11g

The right caching strategy can make a big difference in application performance.

Oracle News / Analyst's Corner: Make the Next Storage Move
« on: July 11, 2011, 04:45:04 PM »
Analyst's Corner: Make the Next Storage Move

Organizations reduce costs by matching the right type of storage to
their needs.

Oracle News / In the Field: Build and Buy
« on: July 08, 2011, 01:45:01 PM »
In the Field: Build and Buy

An Oracle technologist looks at the principles for integrating built and
bought solutions.

Oracle News / OTN Headlines Java 7 Celebration Begins
« on: July 07, 2011, 04:45:02 PM »
Java 7 Celebration Begins

It was a glorious global gathering of the Java community today (on July 7), when Oracle hosted multiple events and a Webcast to celebrate Java 7. With contributions from Java users around the world, Java 7 is a testament to the vibrancy of the Java community and to Oracle’s ongoing commitment to the language and technology.

Pages: 1 ... 103 104 [105] 106 107 ... 144