select *
from mailmessages
where (CONTAINS(body, '%oracle%', 1) > 0)
or (CONTAINS(subject, '%oracle%', 1) > 0)
Appears next error: ORA-29907 : found duplicate labels in primary invocations
Solution : Problem is that we are using same label 1 for both search criteria, therefore we can execute above query without labels or with different labels :
select *
from mailmessages
where (CONTAINS(body, '%oracle%', 1) > 0)
or (CONTAINS(subject, '%oracle%', 2) > 0)
or select *
from mailmessages
where (CONTAINS(body, '%oracle%') > 0)
or (CONTAINS(subject, '%oracle%') > 0)
No comments:
Post a Comment