Skip to Main Content
Easy Text Search over Multiple Tables and Views with DBMS_SEARCH in 23c

About This Workshop

Youtube Video

About This Workshop
Oracle Text provides text content searching over text data types such as VARCHAR2, JSON, CLOB and BLOB. But what if you want a single index that covers many columns and many tables? DBMS_SEARCH makes this easy for you by adding a table or view to an index with a single, simple PL/SQL call. You can then search all of your tables, or just specific table using the CONTAINS and JSON_TEXTCONTAINS operators.

Workshop Info

30 minutes
  • Lab 1:  Create schema objects + populate 
  • Lab 2: Create a DBMS_SEARCH index and add tables. Explore contents of index
  • Lab 3: Run queries against index
  • Lab 4: Add views to the index
  • An Oracle 23c Free Developer Release Database or one running in a LiveLabs environment
  • The IP address and instance name of your compute instance
  • Successfully logged into your LiveLabs account
  • A valid SSH Key (for SSH Terminal Connections only)

Other Workshops you might like