Skip to main content

Ross Pfahler

Member since Jan 28, 2011

Recent Blog Comments By Ross Pfahler

  • Seven Languages In Seven Weeks By Bruce Tate - What An Adventure

    Posted on Jan 31, 2011 at 9:21 PM

    @Ben Not sure if you are referring to the use of a cursors, the 'connect by level', or the use of a regular expression? Either way, all are standard PL/SQL in Oracle. But, given how much licenses cost, I'd say it is all enterprise :)... read more »

  • Seven Languages In Seven Weeks By Bruce Tate - What An Adventure

    Posted on Jan 28, 2011 at 3:40 PM

    A little pl/sql into the mix (one of the many, many ways to do this, I'm sure...especially depending on the collection type). Tested in Oracle 10g by the way. declare   CURSOR nameIsSo (nameList VARCHAR2, verb VARCHAR2) IS SELECT REGEXP_SUBSTR( nameList, '[^,]+', 1, rownum) || ' is so ' ||... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel