Skip to content

Instantly share code, notes, and snippets.

@mineiro

mineiro/gist:631740

Created October 18, 2010 05:03
Show Gist options
  • Save mineiro/631740 to your computer and use it in GitHub Desktop.
Save mineiro/631740 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Gists
Raw
gistfile1.sql
/* Create TABLE INDEX with CTXSYS type */
CREATE INDEX index_name ON TABLE(COLUMN) INDEXTYPE IS CTXSYS.CONTEXT;
/* Select rows with specific text */
SELECT COLUMN, SCORE(1) FROM TABLE WHERE CONTAINS(COLUMN, 'text', 1) > 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment