Oracle select all rows using the contains keyword

Question

Hi, I'm looking for a character which I can use in an oracle conatins to get ALL results.

If I search for the string "test" in a title-column I use this statement:

select * 
from my_table 
where contains (title, 
    '<query><textquery grammar="CTXCAT">test</textquery></query>') > 0

With this statement I get the rows which have the "test"-string included in title-column.

BUT: I there any way to use contains and select ALL rows?

Answer 1

Would this work for you?

select * from my_table
where title like 
    '<query><textquery grammar="CTXCAT">%</textquery></query>'

This uses the LIKE syntax and the % wildcard to achieve what I think you want.

Answer 2

The documentation says wildcards with the Oracle Text CONTAINS() predicate are % and _ just like the LIKE predicate.

Does the following work? I don't have an instance of Oracle handy to test.

select * 
from my_table 
where contains (title, 
    '<query><textquery grammar="CTXCAT">%</textquery></query>') > 0