I'm most pleased to hear this evening-using Oracle's powerful and powerful functions to generate "batch generation of data statements "!

Statement 1:

 

Select rownum, .*
From (select T. brand_name, wm_concat (T. pd_type), wm_concat (T. brand_id)
From base_brand t
Group by T. brand_name)

Statement 2:

Select 'insert into base_brand_info (brand_id, brand_name, brand_name_cn) values ('|
Rownum | ', ''' | A. brand_name | ''', ''' | A. brand_name | ''');'
From (select T. brand_name, wm_concat (T. pd_type), wm_concat (T. brand_id)
From base_brand t
Group by T. brand_name)

Statement 3:

 

Select 'Update base_brand set brand_id = '| rownum | 'where brand_id in (' | A. brand_ids | ');'
From (select T. brand_name, wm_concat (T. pd_type), wm_concat (T. brand_id) brand_ids
From base_brand t
Group by T. brand_name)

Finally:

 

Accurate! Efficient! Simple! Perfect!