DanBrother的部落格

When using the CSSCAN utility (Character Set Scanner), if the output file (scan.err) contains many tables and columns that need to be adjusted, it can take too much time and could be difficult.   Using UltraEdit might be a good way to solve this problem.

CTRL+F   to find the following contents seperately (勾選 列出包含字串的行  & 符合大小寫 的選項)
1. User  :
2. Table  :
3. Column  :
4. Type  :
5.  Max Post Conversion Data Size :

Then Click on "尋找下一個 ", then Click "剪貼簿"

將各剪貼的結果以Alt+C (接換區塊模式) 貼在另一新檔的各欄位,然後即可方便地整理出類似的語法:

alter table test_tab1 modify col1 varchar2(30);
alter table test_tab2 modify col1 varchar2(40);
alter table test_tab3 modify col1 varchar2(50);
alter table test_tab4 modify col1 varchar2(30);
.
.
.