Oracle Split String or Query Result

Hi, just found this Oracle split string. It saves me alot.
Since the first thing came into my head is like:
1. Query and fetch result.
2. Explode or split the result (i use PHP).
3. Perform array search.
Those are computational expensive due to large records.

Hope it helps.