Skip to Main Content
Full-Text Search in Oracle Database

About This Workshop

Youtube Video

About This Workshop
Oracle Text provides full-text indexing capabilities for Oracle database, allowing you to search textual content (such as VARCHAR2 or CLOB data) by specifying words, phrases, or other textual patterns within the content.

The workshop is aimed at developers and DBAs, and covers creating indexes, basic search capabilities, and index maintenance.

Workshop Info

1 hour
  • Lab 1 - Provision an Autonomous Database
  • Lab 2 - Create Indexes
  • Lab 3 - Run Queries
  • Lab 4 - Maintain Indexes
  • Lab 5 - Index files on Object Store
  • Lab 6 - Optional Lab - Sentiment Analysis
  • Basic familiarity with Oracle Database and SQL is assumed

Other Workshops you might like