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 ... 106 107 [108] 109 110 ... 147
How To: Getting Started with Oracle Solaris 11 Express

Brian Leonard explains how to install a full desktop environment of Solaris 11 Express in standalone or multi-boot mode with the new interactive installer. Also explains the diff between regular users, root, and sudo ( Plus SMF, networking, and more.

Developer Day Workshops: Bigger, Better, More!

The new Developer Day schedule is out, and there's something for everybody!

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

Erl and Manes discuss upcoming books in the Prentice Hall Service-Oriented Computing Series and talk about their takeaways from the SOA and Cloud Symposium in Brazil.

PSOUG / Re: REGEXP_SUBSTR Function usage
« on: August 10, 2011, 04:47:04 PM »
Thanks for the help Mike. You really helped me to think about this issue and hunt for a good solution.

I'll be back soon I'm sure!
Glad to be able to help. :)

Oracle News / Oracle Magazine - September/October 2011
« on: August 10, 2011, 04:45:02 PM »
Oracle Magazine - September/October 2011

Oracle Magazine September/October features articles on how x86-based servers are now successfully running business-critical applications, Oracle data integration solutions, upcoming conferences Oracle OpenWorld and JavaOne, interviews with OAUG President Mark Clark and Scott Tracy, senior director of storage software development at Oracle, Part 3 of Steven Feuerstein's series on using and understanding PL/SQL, our technologis Tom Kyte answers your questions and much more.

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.

Pages: 1 ... 106 107 [108] 109 110 ... 147