Hi Tom,

I have a table with 5000 columns which includes columns of different data types, Say 1000 columns of int type, 1000 columns of string type, 1000 columns of float type and so on.
Now my question is to write a query to trim only those string columns say like 3000 columns and its respective records.

Else we can trim all 5000 at once and i can change all other int columns using cast after trimming.

Please help me to solve this.
Thanks in advance

SQL> create table t ( c1 int 
  2         c2 int,
  3         c3 int,
 ....
....
1001    c1001 int );

ERROR at line 1:
ORA-01792: maximum number of columns in a table or view is 1000