Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rremove SPACES from the columns that are converted from CHAR to VARCHAR2

747749Oct 14 2010 — edited Oct 14 2010
Hi All,

In my database I have around 1000 CHAR columns (approx 1 CHAR column each table), I have converted all those to VARCHAR2. I have to remove SPACES from all the columns that are converted from CHAR to VARCHAR2. While Converting from CHAR to VARCHAR2 I have logged the table name and column name in one of the tables.


The average Rowcount of all the tables in my database is 5 Million.

What would be the fastest way to remove spaces from those columns ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2010
Added on Oct 14 2010
#plsql, #sql
9 comments
318 views