SQL query using ? and *

[edwardb15]

can anybody explain the below where clause:

ORA-O*(600?|7445|4[0-9][0-9][0-9])[^0-9]

i get the general idea of it but dont understand the ? after the 600 and the reason for the last [^0-9] outside of () . i know ^ means end of line.
thanks.

 

[SantaMufasa]

Whoa, Edward, I don't see any "WHERE" clause. Could you please post the entire SELECT and a couple of lines of the output it generates? With that, we can probably figure things out.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[lewisp]

It looks like a regular expression, but Oracle doesnt handle them by default.

Am I right in saying you are looking for Oracle error messages that match the regular expression? Where are you looking for them, exactly?

 

[Dagon]

Doesn't regular expression handling come in with 10g ? The expression edwardb15 posted looks more like the sort of thing you have in a shell script to search the log file for errors of a particular kind.