MARKUP (HIGHLIGHT) and MULTI_COLUMN_DATASTORE
984246Feb 4 2013 — edited Feb 4 2013I am passing a text index to MARKUP's index_name parameter, that is a dummy field for MULTI_COLUMN_DATASTORE. Though, MARKUP only returns the CLOB of the dummy field, not the rest of the columns.
What is the best way to MARKUP a "document" that is stored in a table, in multiple columns (columns are either VARCHAR2 in CLOB). I need every column MARKUP'd (or HIGHLIGHT'd).
Alternatively, I can do the markup-ing myself, but in that case I'd like to know, whether there's a way to get all the terms that Oracle searched with. I use the ora-text operator FUZZY a lot, so I'd need to get the additional terms that are generated (expanded?) by the FUZZY operator.
Edited by: 981243 on Feb 4, 2013 5:22 AM