Skip to Main Content
Feature Request FR-2131
Product Area Application Builder
Status CLOSED

11 Voters

Quick Sql - Add Oracle Text Index to column

shunt Public · Oct 30 2021

Idea Summary
In Quick Sql, Provide a shorthand to create a column with an Oracle Text index – eg /oraText

Use Case
What are the use cases in which this idea useful?  I have a table with a column that I know will be used in a faceted search with an Oracle Text Index

Preferred Solution (Optional)
How would you implement this idea? If you are not sure, leave blank.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • carsten.czarski APEX Team OP 2.9 years ago

    are you after simply adding a plain CTXSYS.CONTEXT index to one of the table columns? Most TEXT Indexes need configuration to be set up before (CTX_DDL), and Oracle TEXT parameters are often needed - in my experience I hardly had a situation where the simple CREATE INDEX command was sufficient.

  • simon_hunt OP 2.9 years ago

    Hi Carsten

    If you use the SQL Workshop to add a text index then it adds a plain ctxsys.context index.  I think Quick SQL should mirror that same functionality, perhaps using a syntax like /text or /ti.  I never used an Oracle text index till it became a feature in APEX Search.  Now I use them all the time and would like to add them at the early design stage rather than add them after.  I hope that helps.

  • vincent morneau Admin OP 2.8 years ago

    Hi,

    I wanted to provide an update regarding this idea. In the future, Quick SQL will be developed by the database tools team, which means that this particular idea will not be implemented in the current Oracle APEX implementation. Your idea has been forwarded to the database tools team as they continue to develop Quick SQL.

    Thank you for taking the time to post this idea and we are looking forward to see it implemented in the next Quick SQL version.