Hi Gurus:

We have some corruption (logical) in one of our tables. One of the fields
(a CLOB) has "garbage" characters in it.

Is there a simple way to SELECT all of the records which contain these
garbage characters? I tried a LIKE '%<sample garbage character>%' but
sqlplus just tells me the quoted string was not properly terminated.

Any help would be GREATLY appreciated!

Thanks in advance,

Brian

Oracle LazyDBA home page