Home > IT Answers > Development > REGULAR EXPRESSIONS / META CHARACTERS REGEXP_INSTR
Midolci
0 pts.
 REGULAR EXPRESSIONS / META CHARACTERS REGEXP_INSTR
SQL
I'm a bit confused here. Looking at the Student Guide from the Intro to Oracle 10g SQL class, on page 8-6 (volume II) it states that the ^ represents "Beginning of Line Anchor" then four pages further on 8-10 it states that the ^ inidcates NOT. Can anyone explain? This is the first time I'm seeing REGULAR EXPRESSION SUPPORT and I'm finding it a bit confusing. Thanks,

Software/Hardware used:
ASKED: April 22, 2006  12:30 PM
UPDATED: March 6, 2012  7:57 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Generally, a caret (^) represents “Beginning of Line Anchor”. However, when used inside brackets with selection characters, a caret takes on a second meaning — it means “not these characters”. The expression can’t confuse the meaning because it cannot mean “Beginning of Line Anchor” when it’s inside the brackets.

Words and other symbols can have different meanings when used in different ways. The surrounding symbols can modify the meanings.

Tom

TomLiotta
 110,035 pts.