Results 1 to 3 of 3

Thread: Bad data

  1. #1
    Join Date
    Aug 2003

    Unanswered: Bad data

    Some knuckleheads have used a cutom indexing app to create several thousand records with this problem: The indexing app permitted field entries longer than the db receiving the index. IE, a 100-char entry when the DB only accepted 50 characters. The app had no safeguard against this error.

    Does Oracle or PL/SQL have a function that will allow me to select all records where the content exceeds a certain number of characters in length? Actually in this case it would be better to find strings exactly 50 chars long. The data has been imported to our Oracle db, and I need to find these bad records!

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL



    select * from myTable
    where length(col_x) = 50;

    This will list all rows where col_x is 50 characters long.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    That's it! Thanks.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts