Query multiple keywords from one string
Hi,
I'm trying to build a search page that will give users a keyword search field and search my oracle database for all keywords entered.
I guess I need to look for spaces in the string and seperate out into an array, then build the sql dynamically from each item in the array using a loop.
Can anyone point me to any examples? Most I can find are mysql based so use functions not available in Oracle.
Many thanks.