Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

REGEXP_REPLACE - Replace every occurrence of the letter in the pattern

Karthick2003Dec 1 2008 — edited Jun 19 2013
I need a regular expression query to do the following

Input 
'[karthick] account number is [10000010101] and my pin is [1919128]'
Output 
'######## account number is ########### and my pin is #######'
In short any thing that is between [] should be replaced with #

I tried this.
SQL> with t
  2  as
  3  (
  4     select '[karthick] account number is [10000010101] and my pin is [1919128]' str
  5       from dual
  6  )
  7  select str, regexp_replace(str,'\[[[:alnum:]]+\]','#') str1
  8    from t
  9  /

STR
------------------------------------------------------------------
STR1
--------------------------------------------------------------------------------
[karthick] account number is [10000010101] and my pin is [1919128]
# account number is # and my pin is #
But i want all the letters inside [] to be replaced with #.


Thanks,
Karthick.

Comments

JohnWatson2

It is all in here,

http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf

BPeaslandDBA

From Google Translate: 



What is the end date of the holder 11.2.0.4 ?


Can we keep the standard edition and standard edition licenses one or should we switch to standard edition 2 from 09.16.2016 ?


Finally it is possible to switch to standard edition 2 and stay 11.2.0.4 oracle ?

What is the end date of the holder 11.2.0.4 ?


Answered here: https://blogs.oracle.com/UPGRADE/entry/premier_support_for_oracle_11


Can we keep the standard edition and standard edition licenses one or should we switch to standard edition 2 from 09.16.2016 ?


I can't answer that one. SE2 was recently announced. I know some customers are worried that they won't be able to switch from SE1 to SE2 but I can't say for certain if their fears are valid or not. I don't use SE1 so I don't have first-hand experience.


Finally it is possible to switch to standard edition 2 and stay 11.2.0.4 oracle ?


It won't be. The first SE2 version is 12.1.0.2. There is no 11.2.0.4 SE1.


Hope that helps,

Brian

JohnWatson2

I see I missed one bit of your question: what to do with SE1 licences. Well, nothing! You cannot upgrade your SE1 databases to 12.1.0.2, they must stay at 12.1.0.1 or lower. If you want to go to the current release, you'll have to adjust the licence to SE2 and pay accordingly.

Furthermore, SE1 will no longer be available for purchase after 1 December, so if you want more SE1 licenses, do not hang about.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2013
Added on Dec 1 2008
19 comments
27,127 views