Return all indexed documents that contain the word “”:
SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS ''
Return all indexed documents that contain “” or “” or both:
SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS ''
Return all indexed documents that contain the phrase “”:
SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '""'
Return all indexed documents that contain the word “” or the phrase “” or both:
SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS ' ""'
Return all indexed documents that contain the word “” but not “”:
SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '' AND NOT ''
Return all indexed documents that contain the word “” and are owned by ”:
SELECT object_name, subject, title, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '' WHERE owner_name = ''
Return a summary of attribute values and content from the selected objects:
SELECT SUMMARY FROM type WHERE object_name = ''
Return the list of documents in docbase which are full text indexed:
select count(*) from type where a_full_text =TRUE