Home » SQL & PL/SQL » SQL & PL/SQL » Can an {interval quantifier} contain a REGEXP_INSTR expression (Oracle Data Provider for .NET 10.2.0.5.0 Production)
Can an {interval quantifier} contain a REGEXP_INSTR expression [message #624108] Wed, 17 September 2014 15:05 Go to next message
dmparish
Messages: 1
Registered: September 2014
Location: Texas
Junior Member
I'm trying to insert the expression
REGEXP_INSTR([Thickness Measurement Location].[TML ID], '-', 2, 1)
into the interval quantifier inside {curley brackets} in a REGEXP_REPLACE statement, but so far, have not been successful in getting this to work. None of the book examples I've found indicate that an expression can be used in an interval quantifier. Can someone tell me if this is permitted?

Thanks,
Dale

Report message to a moderator

Re: Can an {interval quantifier} contain a REGEXP_INSTR expression [message #624113 is a reply to message #624108] Wed, 17 September 2014 19:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

What does your post have to do with Oracle RDBMS?

Report message to a moderator

Re: Can an {interval quantifier} contain a REGEXP_INSTR expression [message #624126 is a reply to message #624108] Thu, 18 September 2014 00:46 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the input and what is the output?
Or what is the original value and the final one you want?

Report message to a moderator

Previous Topic: Update command
Next Topic: Help needed with joining two tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 16:43:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.