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: 163
Hi folks,
In Oracle 10g, is there a way to do the following in PL/SQL?
for each table in database
for each row in table
for each column in row
if column is of type 'varchar2'
column = trim(column)
Thanks!
© Stack Overflow or respective owner