How to modify the string length of all tables under a user by a certain proportion in the database

This article will explain in detail how to modify the strings of all tables under a user in the database according to a certain proportion of length. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Application:

1. Import the gbk of oracle into the oracle library of utf8, which needs to be multiplied by 1.5x

2. Import the mysql library into utf8's oracle library, which needs to be multiplied by 3 times.

Set heading off

Set space 0

Set pagesize 0

Set trimout on

Set trimspool on

Set linesize 2500

Spool modify_len.sql

Select 'alter table' | | table_name | | 'modify (' | column_name | |''| data_type | |'('| | ceil (data_length*1.5) | |');'

From user_tab_columns where data_type in ('VARCHAR2','CHAR','NCHAR','NVARCHAR2') and table_name not like' BIN%' and table_name like 'DSJ%'

Spool off

@ modify_len.sql

This is the end of the article on "how to modify the string length of all tables under a user by a certain proportion in the database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.