My Oracle Support Banner

Simulate Item Simple Search Via SQL, Searching Across Columns For Multiple Words and Terms (Doc ID 2201831.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
Simulate Item Simple Search Via SQL, Searching Across Columns For Multiple Words and Terms

Goal

Users are trying to understand the logic of the Item Simple Search in Product Hub (PH / PIM). Can you clarify the logic and how the search can be simulated?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. What columns / objects are searched?
 2. How do multiple word searches behave?
 3. How can one simulate the search in SQL?


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.