trim function to all char columns unix , oracle 10g (Merged) [message #418222] |
Thu, 13 August 2009 08:50  |
dr46014
Messages: 49 Registered: February 2007
|
Member |
|
|
is it possible write apply a trim function to all the varchar or character column of a table.There are around 600 columns in the table and out of which 500 are of char/varchar type.So i want to select all the columns with string type columns trimmed.
can i write less code like select trim(*) ....
something like this..
please suggest
Thanks
Deepak
|
|
|
|
trim function to all char columns [message #418224 is a reply to message #418222] |
Thu, 13 August 2009 08:53   |
dr46014
Messages: 49 Registered: February 2007
|
Member |
|
|
is it possible write apply a trim function to all the varchar or character column of a table.There are around 600 columns in the table and out of which 500 are of char/varchar type.So i want to select all the columns with string type columns trimmed.
can i write less code like select trim(*) ....
something like this..
please suggest
Thanks
Deepak
|
|
|
|
|