Surely, Oracle should have something to help us search for strings embedded in LONG columns?

No?

Otherwise what is the use of only storing data in LONG if you cannot search/retrieve anything in/from it?

can anyone tell me if there are any functions I could use to work with long columns?