How to trim all columns in all rows in all tables of type string?

Posted by daveslab on Stack Overflow See other posts from Stack Overflow or by daveslab
Published on 2010-05-14T16:36:28Z Indexed on 2010/05/14 17:14 UTC
Read the original article Hit count: 210

for each table in database
  for each row in table
    for each column in row
      if column is of type 'varchar2'
        column = trim(column)

© Stack Overflow or respective owner