I figured out how to do it . . . the fields should contain the string "http"
at some point. So by doing a NOT LIKE '%http%', I was able to isolate the
garbage records.

Cheers,

Brian

> -----Original Message-----
> From: Brian Mays
> [mailto:oracledba-ezmlmshield-x71607260.[Email address protected]
> Sent: Friday, May 04, 2007 7:52 PM
> To: LazyDBA Discussion
> Subject: SELECT on "Garbage" fields
>
> 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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST
> REPLY To post a dba job: http://jobs.lazydba.com To Subscribe
> : http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page