I wanted to know what is the difference between placing the carat in front of a parentheses enclosing a search pattern and placing the cara immediately following it
for example
SELECT ADDRESS2,
REGEXP_REPLACE(ADDRESS2,
'(^[[:alpha:] ]+), ([[:alpha:]]{2}) ([[:digit:]]{5})',
'\3 \2-"\1"') THE_STRING
FROM ORDER_ADDRESSES
and
CHECK (
REGEXP_LIKE (EMAIL1,
'^([[:alnum:]]+)@[[:alnum:]]+.(com|net|org|edu|gov|mil)$'
)
)
does the first example imply that [[:alpha:] ]+ is the first string in the following sets of strings
while the second implies that
([[:alnum:]]+)@[[:alnum:]]+.(com|net|org|edu|gov|mil) is the string between ^ and $
Thanks