No, I checked on my 8.1.7.3 database first, and it's there.
I don't have app server installed. I have the source to the package anyway. Don't know if it's wrapped now or not, but I don't think so... Nope, not wrapped: $ORACLE_HOME/rdbms/admin/pubpat.sql $ORACLE_HOME/rdbms/admin/privpat.sql Jared On Monday 01 July 2002 13:48, Grabowy, Chris wrote: > JS, > > Doesn't that owa_pattern package come from the PL/SQL Web Toolkit, which > requires that you have the Oracle App Server licensed?? > > -----Original Message----- > Sent: Monday, July 01, 2002 4:23 PM > To: Multiple recipients of list ORACLE-L > > > Yes, use regular expressions via the owa_pattern package. > > Here's an example: > > declare > tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 > dig2its'; > begin > dbms_output.put_line( tstr); > -- remove the digits > owa_pattern.change( tstr, '\d', '', 'g'); > dbms_output.put_line( tstr); > -- remove the extra spaces > owa_pattern.change( tstr, '\s+', ' ', 'g'); > dbms_output.put_line( tstr); > end; > / > > Jared > > > > > > Nils Höglund <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/01/2002 04:18 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: Remove numbers from string > > > > Is there any way to remove all numbers from a string? > > The string might look like this: 'abc123def432' > and I wan't it to look like this: 'abcdef'. > > I'm using Oracle 8. > > > Thanks in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
